INT vs Unique-Identifier for ID field in database...

Optimizing SELECT COUNT to EXISTS...

Retrieve only the records before a specific patterns happen...

Remove minutes and seconds and then convert to UTC timezone...

Outer join entire date table with aggregate on business table...

SQL Script that will adjust the value of the next row when it finds a negative...

SQLCMD in Shell Script Does Not Exit After RESTORE...

Deduplicating IDs accros two columns...

How to insert default values in SQL table?...

In SQL Server, what does "SET ANSI_NULLS ON" mean?...

Generic expression to find partial string matches against dynamic list of fields in LINQ query...

Is there an Implode type function in SQL Server 2000?...

How to return multiple values in one column using T-SQL...

How can I group fields from multiple records in T-SQL by another field?...

Why does division return zero...

SQL restore single table from backup database. Columns has timestamp and I must use IDENTITY_INSERT...

How to get the list of all tables that have identity columns...

Selecting COUNT(*) with DISTINCT...

Take data from Lead Record when condition or filter criteria matches and ignore the records between ...

Update SQL with consecutive numbering...

SET NOCOUNT ON usage...

SQL MAX of multiple columns?...

How to find out what row caused a T-SQL statement to fail...

How do I handle sqlcmd.exe "Timeout expired" message, which doesn't appear to be an er...

SQL: Insert from first table into second table when records not exist in second table...

how to avoid the "Type conversion in expression" when using HASHBYTES...

Calculate the end date of partition rows using the start date of the following partition...

Calculate end date of partition rows using start date of following partition...

How do I UPDATE from a SELECT in SQL Server?...

Find a value anywhere in a database...