SQL Server Query Tuning Best Practices - Part 1
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 goes over query tuning methodology and what is needed to measure query performance. Then, Aaron discusses Default Cursors, Correlated Sub-Queries, and Not In.
Find more information about our products:
Plan Explorer: http://www.sqlsentry.com/plan-explorer