sql-server-2008 tutorials

Binary datatype for Primary Keys Vs Int?

Oct 02, 2022

sql-server sql-server-2008

How to select a max row for each group in SQL

Nov 12, 2022

sql sql-server sql-server-2008 tsql greatest-n-per-group

TSQL: Is there a way to limit the rows returned and count the total that would have been returned without the limit (without adding it to every row)?

Oct 04, 2022

sql sql-server sql-server-2008 tsql sqlclr

Check for two decimal digit number in string

Apr 28, 2022

sql sql-server sql-server-2008 select

What happens if SQL Server job steps are modified during execution

Mar 15, 2020

sql-server sql-server-2008 tsql

Merge rows if date columns are overlapping in TSQL

Apr 26, 2022

sql sql-server tsql sql-server-2008

How to perform a row lock?

Sep 12, 2022

c# sql sql-server-2008 locking

Ways to Maintain Data History in SQL Server 2008 Database

Nov 12, 2022

.net sql sql-server-2008 entity-framework-4 change-tracking

sql server 2008 return value getting shortened when using ISNULL and NULLIF

Oct 14, 2022

sql-server-2008 isnull

An invalid floating point operation occurred. SQL Server 2008

Mar 06, 2020

sql sql-server-2008 sql-server-2008-r2 floating-point-exceptions

User defined TYPE across databases

Jun 26, 2019

sql-server-2008 tsql user-defined-functions

T-SQL procedure - filter parameter as Object/CLR/Xml/UDT

Feb 28, 2022

sql sql-server-2008 tsql parameters filtering

SQL evaluation of IF clauses

Mar 13, 2017

sql sql-server-2008

Search a column name across all databases

Dec 27, 2018

sql-server-2008 information-schema

Passing a user-defined table type between SQL Server database

Oct 23, 2022

sql-server sql-server-2008 user-defined-types

How do I drop all functions from CLR Assembly before it's drop in SQL Server?

Sep 10, 2022

sql-server-2008 .net-assembly universal

sql server database timezone different from system timezone

Nov 01, 2022

sql-server-2008 sql-server-2005

SSIS OLEDB destination with SQL command

Sep 18, 2022

sql sql-server-2008 ssis oledb

Disable users of a database not Logins in SQL server 2008

Nov 01, 2022

sql-server database sql-server-2008 tsql database-administration

Rounding issue in LOG and EXP functions

May 06, 2022

sql sql-server sql-server-2008 sql-server-2012

New posts in sql-server-2008