SQL Server MVPs Aaron Bertrand and Kevin Kline begin their series on query tuning best practices. They go over some tips and tricks for writing queries. First, Kevin spends a little time on how to approach your SQL query tuning methodically from a methodology, a process standpoint. He also goes into what is needed to measure query performance and what it takes to analyze the different touch points along the ways as you look at a set of SQL queries. Aaron then jumps into some patterns and anti-patterns such as default cursors, correlated sub-queries, and not in. He then takes you through demos of each and shows you some of the things to improve overall functionality of each.
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.