Index Fragmentation - Internals, Analysis, and Solutions

Index Fragmentation - Internals, Analysis, and Solutions

PASS Data Community Summit via YouTube Direct link

Singleton Lookup

5 of 19

5 of 19

Singleton Lookup

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Index Fragmentation - Internals, Analysis, and Solutions

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 The SQLskills Team
  3. 3 Overview
  4. 4 Index Structure
  5. 5 Singleton Lookup
  6. 6 Range Scan
  7. 7 Range-Scan: Readahead (1)
  8. 8 Logical Fragmentation Defined
  9. 9 Low Buffer Pool Usage
  10. 10 What is a Page Split?
  11. 11 Updates During a Page Split
  12. 12 Page Split Mechanism
  13. 13 Tracking Page Splits
  14. 14 What Causes Fragmentation?
  15. 15 Real-World Examples
  16. 16 Configuring FILLFACTOR
  17. 17 sys.dm_db_index_physical stats a
  18. 18 How to Correct Fragmentation?
  19. 19 ALTER INDEX ... REBUILD

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.