Index Design and Tuning

Deduplicate Indexes - Level 1 SQLChallenge (56 minutes)

Deduplicate Indexes - Level 1 SQLChallenge (56 minutes)

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?

Index Design SQLChallenge - One Year Wonders (50 minutes)

Index Design SQLChallenge - One Year Wonders (50 minutes)

This challenge comes in three possible levels of difficulty: choose one or work through them all!

Learn Indexing by Solving Problems (7 hours 23 minutes)

Learn Indexing by Solving Problems (7 hours 23 minutes)

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.

How Index Keys and Includes Work (1 hour)

How Index Keys and Includes Work (1 hour)

Build your powers of index design by learning how indexes are structured in SQL Server.

Try the course quiz anytime.

Indexing for Windowing Functions (45 minutes)

Indexing for Windowing Functions (45 minutes)

Get the best performance for your windowing functions.

Execution Plans: Partitioned Tables and Columnstore Indexes (1 hour 30 minutes)

Execution Plans: Partitioned Tables and Columnstore Indexes (1 hour 30 minutes)

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!

Try the course quiz anytime.

Why Creating an Index Can Slow Down a Query (1 hour 30 minutes)

Why Creating an Index Can Slow Down a Query (1 hour 30 minutes)

Sometimes performance can go badly wrong if SQL Server has an imperfect index for an query.

Try the course quiz anytime.