Finding Available Keys When Merging Two Tables

Find available keys when merging two tables with duplicate keys.

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.

Returning Data from Stored Proc

Query

Delete Duplicates

Bit data

The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.

ANSI_NULLS

Implicit Conversions

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.