How to rollback or commit a transaction in SQL Server...

SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes...

What's the best way to select the minimum value from several columns?...

Base64 encoding in SQL Server 2005 T-SQL...

Are SQL execution plans based on schema or data or both?...

Export table data from one SQL Server to another...

Generate a resultset of incrementing dates in T-SQL...

SQL Server Subscription Initialization Restarts Endlessly, Never Finishes...

Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?...

Invalid length parameter passed to the LEFT or SUBSTRING function in Sql Server...

What is the maximum characters for the NVARCHAR(MAX)?...

Better techniques for trimming leading zeros in SQL Server?...

SQL Query to get latest price...

SQL Server 2005 filtering and paging with ROW_NUMBER()...

Data Paging in SQL Server 2005 Only Returns 1 (One) Row...

How can I rename my column in a SQL table?...

Grid view - Column...

There is already an object named '#columntable' in the database...

Backup SQL Schema Only?...

Keyboard shortcut for "Connect to Server" in Management Studio...

Create failed for Database...

Why Does SQL Update Top apparently reduce locking even when no records are updated?...

SQL Server - transactions roll back on error?...

Schema from stored procedure...

How can I solve a connection pool problem between ASP.NET and SQL Server?...

Real life example, when to use OUTER / CROSS APPLY in SQL...

Determine available disk size with a sql query...

How to set collation for a connection in SQL Server?...

Script to save varbinary data to disk...

Apply like over all columns without specifying all column names?...