SQL Server articles
24-SEP-2013
Fragmentation hurts performance
13-MAR-2013
Optimize date range queries
04-SEP-2011
Calculate Age using TSQL
07-AUG-2010
Why not to use "SELECT * FROM ..." in production code
25-MAR-2010
Always declare your index as Unique
10-JAN-2010
How to verify an IP Address using TSQL
28-NOV-2009
Using correlation to improve query performance (abstract)
09-NOV-2009
Bin Packing - Approaching the perfect match
SQL Server reference material
16-FEB-2013
Maximum Capacity
10-AUG-2010
Data Types
SQL Server optimizer improvements
16-MAY-2011
Improvement in 2005 - Pass Through enables optional joins
24-FEB-2013
Improvement in 2000/2008 - Optimize predicate order evaluation in IF (@a = 1 OR @b = 2)
22-FEB-2011
Improvement in 2005 - Rewrite IF (SELECT COUNT(*) ...) > 0 to IF EXISTS
10-APR-2010
Improvement in 2000 - Eliminate referenced table if outer joined and no columns are selected
20-JUL-2008
Tip - Improve free text searches in 2000 or earlier
20-JUL-2008
Improvement in 2005 - String Summary statistics to improve free text searches
06-JUL-2008
Possible improvement - Eliminate referenced table for all scenario's of Foreign Key and no selected columns
08-AUG-2011
Improvement in 2000 - Eliminate referenced table if Foreign Key constraint exists and no columns are selected
17-MAY-2008
Possible improvement - Execute TOP (n) before Outer Joining
17-MAY-2008
Improvement in 2005 - Sorting resultset before Loop Joining
17-MAY-2008
Flaw in 7.0 - Outer Join does not seek on full compound index key