SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. Kevin starts by talking about what you should include in test harnesses for testing your SQL code and how to isolate it and stabilize your environment in order to get consistent results. He then gives some tips on how to assess those results. The patterns and anti-patterns that are in the video are UNION vs. UNION ALL, Index Structures, and Compound Indexes. Aaron and Kevin include Covering Indexes as a bonus.
Click here to find out the winners of the Richard Petty Driving Experience: sqlsentry.tv/who-is-the-worlds-fastest-dba/
Note: eBook no longer available via Amazon. Email firstname.lastname@example.org if you are still interested in receiving a copy.