sql-server-2008 tutorials

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

Why doesn't EF 4 generate association for FK relation to column with unique index?

May 10, 2022

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

SqlDbType and Geography

Jul 26, 2019

sql sql-server-2008 ado.net

t-sql output of updated results

Feb 28, 2017

sql-server-2008 tsql

Same query - different execution plans

Oct 17, 2022

sql sql-server sql-server-2008 query-optimization sql-execution-plan

New posts in sql-server-2008