SQL Server Performance Tuning and Optimization

SQW07 Ten Query Tuning Techniques Every SQL Developer Should Know


4:00pm - 5:15pm

Level: Intermediate

Kevin Kline

Head Geek


SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

You will learn:

  • Implement a reusable Transact-SQL test harness for reliable query results.
  • Ten patterns that kill the performance of SELECT statements and how to avoid them
  • Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves