How to Think Like the SQL Server Engine

You’re comfortable writing queries to get the data you need.
But you're uncomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries into results. You know there are execution plans, but ... you're uncomfortable reading them. You know queries need indexes, but you're not sure which columns to put in order, or how SQL Server chooses between them.
I'd like to teach you, for free!

[@barrowmusics]

I mostly love videos with timestamps, but all the same great video

[@BrentOzarUnlimited]

Glad you like them!

[@emersonpup]

This is making me look back in pain at all of my shitty query tuning attempts at my last job

[@BrentOzarUnlimited]

I know, right? That's my entire career...

[@TheColjackoneal]

Everytime Brent steps out of frame it looks like he's been snapped by Thanos 🤣

[@BrentOzarUnlimited]

HA!

[@DatabaseAdministration]

If i may ask, to know all this what did you do? Any books ? courses? offical docs?

[@benjaminberger9629]

I really, really like your content, but do you hear your soundboard while it is playing? At the volume it is playing at in the video? 😁

[@BrentOzarUnlimited]

TURN DOWN FOR WHAT

[@DeborahGSams]

do all function invalidate index usage?

[@BrentOzarUnlimited]

Great question! We talk about that in detail in both my Fundamentals of Index Tuning class and my Fundamentals of Query Tuning class. The short answer is no, though.

[@j.r.3215]

💯👏👏👏

[@ayndeg5944]

👏👏🙏

[@Tony-dp1rl]

"How to Think Like the SQL Server Engine" ... that's easy, just invoice everyone thousands of dollars every time you say something. :)