Level: Intermediate

Don Jones

MVP

Curriculum Director for IT Pro Content

Pluralsight

Index and PTO geek Don Jones takes you on a backstage tour of indexes.

SQL Server indexes are an absolutely crucial part of SQL Server performance – but do you know how they REALLY work? Like, under the hood? Index and PTO geek Don Jones takes you on a backstage tour of indexes. You'll learn about B-trees, clustered and non-clustered indexes (separating myth from fact), how indexes consume storage and become fragmented, and how – over time – index design MUST be revisited and revised on ANY database.

You will learn:

• Choose the right kind of index (there's more than two!)
• Learn WHY and HOW index maintenance becomes necessary
• Get hard numbers on index tuning and maintenance