Think Like a Terminator - Internals of Classic SQL Server Indexes

Think Like a Terminator - Internals of Classic SQL Server Indexes

PASS Data Community Summit via YouTube Direct link

Database file structure

3 of 14

3 of 14

Database file structure

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Think Like a Terminator - Internals of Classic SQL Server Indexes

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

  1. 1 Introduction
  2. 2 Disclaimer
  3. 3 Database file structure
  4. 4 Why use indexes
  5. 5 Clustered indexes
  6. 6 Clustered index details
  7. 7 Clustered index demo
  8. 8 Page splits
  9. 9 Fill factor
  10. 10 Fill factor test
  11. 11 Nonclustered indexes
  12. 12 Clustered and covert indexes
  13. 13 No clustered index
  14. 14 Potential problems

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.