You may be familiar with ROW_NUMBER(), but did you know you'll also need to combine that with a Common Table Expression (CTE) to paginate through your records?

Free SQL Server 2000/2005 function that will calculate the distance in miles between 2 latitude/longitude points for zip or address raduis search, etc.

MSSQL Syntax for creating a comma-delimited string from a single column query using only a single SELECT statement

A very useful MSSQL Stored Procedure that will generate a cross tab (pivot table in the Excel world) output