New Year's Eve

All the rows before this one

T-SQL Arithmetic and Geometric Sequence (Series)

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)

Windowing Ranges

A few reflections on RBAR by a weary application developer

Follow the guidance of your DBA, but remember, he or she is from another land.

Declare @local variable

Order My Data

Wildcards II

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.