T-SQL Tuning Step by Step

Thanks for watching my presentation!  Here’s the links I discussed during the presentation:

Presentation Sample Files:

• StackOverflow Users Spreadsheets – taken from the StackOverflow Creative Commons Data Dump, a free data export from the fine folks at StackOverflow.com.

Books:

• SQL Server 2008 Internals and Troubleshooting – the book I coauthored with other Microsoft Certified Masters and experts.  This is not your typical internals book – it’s strictly real-world with tips you can use to figure out which queries are running slow right now.
• SQL Server Query Performance Tuning Distilled – fantastic book that explains indexes, statistics, query plans, and much more.

Scripts & Tools:

• How to Use sp_WhoIsActive – very cool free replacement for sp_who that shows you what queries are running slow on your server right now.
• ClearTrace – free tool to slice and dice Profiler trace results.

Concepts:

• SARGability: Why %STRING% Is Slow – why functions in the where clause can bring your server to its knees.