sql-server-2008 tutorials

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

Aug 05, 2021

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

Which is the best way to perform pagination on SQL Server?

Jun 19, 2019

c# sql visual-studio-2010 sql-server-2008 pagination

Is SQL Server DRI (ON DELETE CASCADE) slow?

Nov 25, 2019

sql-server performance sql-server-2008 cascade

What is the performance of "Merge" clause in sql server 2008?

Oct 25, 2022

sql-server-2008

Generating the SQL query plan takes 5 minutes, the query itself runs in milliseconds. What's up?

Nov 01, 2022

sql sql-server tsql sql-server-2008 stored-procedures

How do I add breakpoints to a stored SQL Procedure for debugging?

Jun 15, 2017

sql debugging sql-server-2008 breakpoints

SQL Number - Row_Number() - Allow Repeating Row Number

Sep 26, 2022

sql sql-server sql-server-2008 row-number dense-rank

How to add more OR searches with CONTAINS Brings Query to Crawl?

Jul 02, 2022

sql-server sql-server-2008 full-text-search full-text-indexing

Avoiding deadlock by using NOLOCK hint

Nov 20, 2022

sql-server-2008 deadlock

How do we alias a Sql Server instance name used in a Connection String .config?

Sep 05, 2022

sql-server visual-studio-2010 sql-server-2008 entity-framework-4 connection-string

New posts in sql-server-2008