sql-server-2008 tutorials

Error 17886 - The server will drop the connection

Feb 16, 2021

sql-server sql-server-2008 windows-server-2008-r2

T-SQL: Paging WITH TIES

Oct 23, 2022

sql sql-server-2008 tsql

SQLCmd with connection string

Nov 04, 2022

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012 sql-server-2014

Handling the data in an IN clause, with SQL parameters?

Nov 07, 2022

vb.net sql-server-2008 tsql sql-injection language-features

SSIS Package runs for 500x longer on one server

Nov 05, 2022

sql-server sql-server-2008 ssis windows-server-2008 windows-server-2008-r2

How to persist a calculated GEOMETRY or GEOGRAPHY column

May 09, 2021

sql-server sql-server-2008 spatial

How to automatically script the securables assigned to a SQL account?

Oct 12, 2018

sql sql-server tsql sql-server-2008

Entity Framework 4 Table Per Hierarchy - How To Define Navigational Properties On Children?

Feb 16, 2022

c# sql-server-2008 entity-framework entity-framework-4 table-per-hierarchy

Trigger causing a deadlock?

Feb 28, 2022

sql-server sql-server-2008 triggers deadlock database-deadlocks

SQL filtered indexes: should I always put a filter on an index for optional columns?

Aug 05, 2021

sql sql-server-2008 indexing filtered-index

Why change user type to SQL user with login is disabled in SSMS?

Sep 13, 2022

sql database sql-server-2008 security ssms

How do I reconstruct a historical view?

Oct 30, 2021

sql sql-server sql-server-2008 cdc change-data-capture

SqlBulkCopy.WriteToServer not reliably obeying BulkCopyTimeout

Nov 10, 2022

c# .net sql-server-2008 timeout sqlbulkcopy

SQL: How can I get the number of executed queries per database or hour or ...?

Nov 14, 2022

sql sql-server-2008 statistics performancecounter sql-server-profiler

How to rollback without transaction

Oct 31, 2022

sql sql-server-2008 rollback

Connecting to MSSQL server in PHP using integrated authentication

Oct 17, 2022

php sql-server-2008 windows-authentication

Why did SQL Server Management Studio 2008 command-line switches stop working?

Oct 21, 2022

command-line ssms sql-server-2008

Fastest way to insert into a SQL Server table from .NET code?

Feb 21, 2019

sql-server-2008 sqlbulkcopy

How to make SQL Server find a login matching the name provided?

Nov 20, 2022

sql-server-2008 login sql-server-express

Inserts in Merge Replication database are insanely slow

Mar 28, 2017

sql sql-server-2008 merge-replication

New posts in sql-server-2008