SQL Server 2008 adds inline variable assignment, so DECLARE @MyVar INT = 5 works in one line. I compare it with the SQL Server 2005 way of DECLARE then SET.
SQL SERVER – Order Of Column In Index
Adding more columns does not make an index better. The order of column in index matters most, since an index is used only when its first column is in the query.
SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
Twelve tips for better SQL Server 2005 query performance, from execution plans and covering indexes to avoiding cursors, using APPLY and archiving old data.
SQL SERVER – Ideal TempDB FileGrowth Value
What is a good TempDB FileGrowth value? Here are simple size-based guidelines, from 10 MB growth for small files to 10 percent for large ones.
What Is an Index in SQL Server?
An index in SQL Server took one query from 33,517 reads to 66 on the same table. What clustered and nonclustered really mean, why every index is paid for on the way in, and how to find the ones nobody uses.
SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
Reader Praveen Barath adds his own query optimization tips to my rules of thumb: tune only working code, write repeated statements identically and more.






