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!

Previous Post
Watch Brent Tune Queries: Fixing Nested Functions
Next Post
Updated First Responder Kit with Your January Code Resolutions

6 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.