Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of TempDB
Before the Class
Prerequisites
Introductions and Overview (3:14)
Download the Slide Decks & Scripts
Fundamentals of TempDB
How the Version Store Affects TempDB (23:45)
How Temp Tables Are Different from Regular Tables (27:31)
How Table Variables Can Be Better Than Temp Tables (15:41)
Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention (21:14)
How Memory-Optimized Table Variables Reduce Contention (19:20)
How Execution Plans Use TempDB (26:53)
Other TempDB Consumers: Cursors, Index Builds, AG Statistics (20:12)
How to Provision and Monitor TempDB (19:24)
How Table Variables Can Be Better Than Temp Tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock