Your challenge is to de-duplicate the indexes on a table in a sample database. Can you predict which indexes are the safest ones to drop?
This challenge comes in three possible levels of difficulty: choose one or work through them all!
SQL Server asks for a lot of indexes — but it does NOT always ask for the right index!
You need to know the essential principles of index design to create the best nonclustered index, filtered index, or indexed view to speed up your critical queries.
Build your powers of index design by learning how indexes are structured in SQL Server.
Get the best performance for your windowing functions.
Execution plans are incredibly helpful when it comes to tuning queries using partitioned indexes and columnstore indexes – but when you look closely, you’ll notice that some things are very weird!
Sometimes performance can go badly wrong if SQL Server has an imperfect index for an query.