How To Read SQL Server Execution Plans

Check out the blog post for more examples and links:

Follow me on Twitter:

[zanonilabuschagne]

Damn bro, you can't tell everyone about "missing index details" - how will us consultants survive :P

Just kidding, once had an incident with a DBA who literally just used that as a basis for his version of performance tuning... Everytime a report was slow, he'd check the exec plan just to see if it needed an index, and VERBATIM just apply it... The fact that there was a plethora of implicit conversions (some issues with his keys), and a slow HDD in the server obviously had nothing to do with performance.

Great vid as always!!

[CalvAnon]

Great tutorial- you have a subscriber! This will be my go to channel for SQL related topics.

[akensturgeon]

Thanks Bert, appreciate you're efforts to teach others.

[ReuelRamos]

Great content man 👍🏻
I like that you cut to the chase on your topics.

[menasheaharonian]

Basic things, but I didn't know some of them. Appreciate it.
Will be happy to see some videos of hands-on optimization for complex queries.
Thank you 🙏

[tomservo]

I"m glad you made this but I would have liked to see more of a deep dive into what to do with the costs including where to put indexes. For example, I have in my plan a Hash Match (Right Outer Join) at 23% cost. I know you mentioned earlier these are causes for concern, but what do I DO (if anything) about it? Nice video overall though.

[souravbanerjee]

Hi Bert, Can you make a series on Oracle PL/SQL execution plan as well? Or how similar / different it is from SQL server ? Many Thanks!

[MrPierrot]

Thanks Bert. On percentage cost, well in the end it is always 100%! May be the focus has to be on 'high' percentage for 'small' data volume (small arrows), as it potentially means lot of cost for small output ? (because of non-SARG item for example)

[giriteja]

Hello, can you make video of ms SQL database exam and practicing for exam in simply method using website are any application