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!!
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 🙏
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.
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)
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!!
Great tutorial- you have a subscriber! This will be my go to channel for SQL related topics.
Thanks Bert, appreciate you're efforts to teach others.
Great content man 👍🏻
I like that you cut to the chase on your topics.
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 🙏
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.
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)
great video, thanks
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!
Hello, can you make video of ms SQL database exam and practicing for exam in simply method using website are any application
giriteja nidgonda agreed with you, Bert plz start with DBA 2016 70-764 will be a great start ...
Great videos! Help me a lot
Are you Austrian?
Please rename the video number 3
bla bla bla