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