Think Like a Terminator - Internals of Classic SQL Server Indexes
PASS Data Community Summit via YouTube
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session examines how SQL Server stores and uses clustered and nonclustered indexes, using DBCC commands to inspect database pages. It covers index performance, page splits, fragmentation, fill factor, and index maintenance.
Syllabus
Introduction
Disclaimer
Database file structure
Why use indexes
Clustered indexes
Clustered index details
Clustered index demo
Page splits
Fill factor
Fill factor test
Nonclustered indexes
Clustered and covert indexes
No clustered index
Potential problems
Taught by
PASS Data Community Summit