How to Think Like SQL Server

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 with Brent Ozar, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.

“In the first 30 minutes, your videos were able to accomplish what I have tried for 1 year to get my team to understand. Your videos are well worth the money!” – Anthony S., ISV Team Lead, about our How to Think Like the SQL Server Engine course

[maxbutton id=”37″]

 

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
  • What happens when those estimates are wrong
  • When you should get fresh estimates by recompiling the query
  • How to avoid SQL Server’s public toilet, TempDB
  • And it’s all demoed with these Stack Overflow database pages (PDF)
[maxbutton id=”37″]
Menu
{"cart_token":"","hash":"","cart_data":""}