Your challenge

Follow the script to set up a problem in your test instance of SQL Server.

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?

Challenge difficulty

This is designed as a 200 level challenge.

Scripts

Grab the scripts: https://github.com/LitKnd/SQLWorkbooks/tree/main/deduplicating_indexes_sqlchallenge

Modules

Your Challenge

Lesson

• Challenge Setup (5 minutes)

Solution

Lessons

• Scripting Out All the Indexes (15 minutes)
• Grouping the Indexes for Analysis (11 minutes)
• Analysis and Deduplication (22 minutes)
• Summing Up and Looking Ahead (3 minutes)