You've done a lot trying 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 course, 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 what their shortcomings are.
95 Minutes, Streaming