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 helper method to convert a SQL query to CSV format for easy output to a file, the console, or via a HttpResponse (for you ASP.NETers out there looking for an easy way to dynamically output a CSV for real-time data download).

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.

What do I mean by dynamic text form fields? Let's say I have a table Contacts that stores typical contact information for a Contact Management system...

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