When someone tells you a query is slow, you need to have a process for figuring out why. 

If your process involves reboots, rebuilds, clearing caches, or digging through a folder full of dusty scripts that you're not sure of, you need to attend this talk.

We'll be looking at query plans, code, indexes, and how the way they get used can all change when you least expect it.

This is a demo heavy session, but you'll walk away with the steps and resources I use every day to solve people's worst problems.
(no tags)
The video is not available to view online.