Using Index Intersection to Boost SQL Server Performance - 28 Feb 2003

Speeding UPDATEs Using the CASE Statement - 30 Dec 2002

Save Space To Boost SQL Server Performance - 31 Oct 2002

Speed Tips For SQL Server SELECT Statements - 30 Aug 2002

Speed Up SELECT DISTINCT Queries - 30 Jun 2002

Getting The Best From The SQL Server Index Tuning Wizard - 10 Apr 2001

Avoiding Bottlenecks with Temporary Tables - 05 Apr 2000