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!

[@DatabaseAdministration]

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

[@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...

[@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

[@TheColjackoneal]

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

[@BrentOzarUnlimited]

HA!

[@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]

👏👏🙏

[@EndUser-yu7gg]

Seek beats Scan.... Scan beats Battlestar Galactica 😜
Covering index is good but not if the engine just keeps saying ever single additional query needs its own nci too 🤦‍♂️

[@BrentOzarUnlimited]

Yep, we build on that in our Fundamentals of Index Tuning class, where we explain how to create as few indexes as possible for as many queries as possible. See you there!

[@Tony-dp1rl]

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