In yesterday’s post, we covered some of the basics of designing nonslustered indexes to make queries go faster, but sometimes those aren’t quite enough.
In today’s post, I’m going to give you more of my paid training about filtered indexes and indexed views.
What I cover here is how to use them correctly, and some of the things they just don’t work well with. Again, if you like what you see, hit the link at the end of the post for 75% off.
Here’s the intro to filtered indexes
Here are the demos:
Here’s the intro to indexed views:
Here are the demos for indexed views:
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.