You've tried everything you know to tune that query, but it's just not going any faster. There are some performance problems holding you back, and you're not sure how to fix them.
In this Advanced Index Tuning class, you’ll learn about filtered indexes, computed columns, and indexed views. I want to teach you how they work, what kind of problems they can solve, and their shortcomings.
95 Minutes, Streaming