Deduplicate Indexes – Level 1 SQLChallenge (56 minutes)

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

Menu