You've got slow query, and you're not sure where to start hunting down problems. Before you go down the rabbit hole, start here to learn about the more common, easy to fix issues you'll see.
Also, there are no rabbits in there. It's snakes. Just snakes.
In this series of videos, you'll learn all about performance issues like implicit conversion, SARGability, why your query just won't seem to go parallel, lookups, and more!
As a bonus, you'll also get a gentle introduction to how the optimizer works.
120 Minutes, Streamed