How to Think Like the Engine – 2019 Edition
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.
In 90 minutes of videos, you’ll learn:
- The differences between clustered and nonclustered indexes
- How (and when) to make a covering index
- The basics of execution plans
- What determines sargability
- What SQL Server uses to estimate the memory your query needs
And more. To follow along, print out this 5-page PDF built from Stack Overflow’s database pages. Here’s the first module:
Wanna keep watching?
To see the rest and get the slides & scripts, head on over to How to Think Like the Engine. Enjoy!
6 Comments. Leave new
A bit hard to read some of the text at 360p… Thanks for making this!
YouTube’s in the midst of encoding the videos still – they’ll be at 1080p eventually. (I uploaded ’em in super-high resolution.)
Nevermind…. Must have been my connection. 1080p now.
Just saw your reply. Makes sense! Learn something new everyday. Thanks!
No, it’s YouTube. When a video first gets uploaded, they start with a low-res version, and gradually build out higher resolution versions over the coming minutes/hours depending on load.
Just finished all 3 videos – great content! I’ve had limited exposure to indexes, so this was quite eye-opening. Thanks!