Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Think Like a Terminator - Internals of Classic SQL Server Indexes

PASS Data Community Summit via YouTube

Start learning Write review
Corporate Finance Institute Ad

Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

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

Reviews

Start your review of Think Like a Terminator - Internals of Classic SQL Server Indexes

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.