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.
Presented by Kevin Kline at SQLBits XIV
MP4 Video HD 632 MB