SQLBits 2015

Ten 10 Query Tuning Techniques Every SQL Programmer Should K

Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.
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'll learn four important lessons, along with 10 other must-have query tuning techniques:

Lesson 1: Implement a reusable Transact-SQL test harness for reliable query results.

Lesson 2: How to best simulate a large production instance on a small development server.

Lesson 3: Learn ten patterns that kill the performance of SELECT statements and how to avoid them.

Lesson 4: Discover the high-impact metadata that shows how a SELECT statement behaves … or
misbehaves.