SQL Server Administration and Maintenance

SQT04 Everything You Never Wanted to Know About Indexes, but Have to Know Anyway

11/19/2013

9:30am - 10:45am

Level: Intermediate

Don Jones

MVP

Curriculum Director for IT Pro Content

Pluralsight

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