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