How To Read SQL Server Execution Plans

[@zanonilabuschagne7628]

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.

[@menasheaharonian9183]

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 🙏

[@tomservo75]

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.

[@giriteja258]

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

[@prathameshkinareparth]

giriteja nidgonda agreed with you, Bert plz start with DBA 2016 70-764 will be a great start ...

[@souravbanerjee1692]

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!

[@MrPierrot69]

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)

[@AbbasKhan-ud6mr]

great video, thanks

[@gianpanacioni4937]

Great videos! Help me a lot

[@cedricsoumahoro8561]

great great great

[@gykg3202]

Are you Austrian?

[@somaya.moustafa]

Please rename the video number 3

[@wonderfulworldwelive]

bla bla bla