SQW03 Everything You Never Wanted to Know about SQL Server Indexes

11/19/2014

9:15am - 10:30am

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