SQL Server Execution Plans - Part 1
Vložit
- čas přidán 21. 07. 2024
- I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review the basics of execution plans and how you can use them to improve the performance of your own queries.
Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBer...
Check out the full post for example queries and screenshots:
bertwagner.com/2019/07/23/int...
Follow me on Twitter:
/ bertwagner - Věda a technologie
This will be a very valuable series for my team at work. Thanks!
Thanks Bert, this is exactly what I was hoping you'd teach.
Thanks Bert! First video is very good ! Lest start the second one !
Looking forward to part 2!
Excellent video and explanation - thanks very much for friendly tone as well, very easy to follow
You know what? There is a lot of people thinking about execution plans like something related to some ancient Guru on top the Himalaya... so they ignore it at every cost it would take...
Great work!
Great introduction, Bert!
Well done, Bert!!! Thanks for this one - have told my team to go watch. Getting the basics right always helps!!
BUT, multiple camera angles??? wow, you're getting professional now :)
Can't wait for part 2 - thanks, and appreciated, as always
Looking good, Bertie!
Just waking up! First thing yo do see this video thanks foto sharing tour knowledge keep up.
Amazing video ..... Learning many new things
Great video Bert!!!
Thank You so much for thinking and taking time to start this awesome series which crucial part of SQL DBA daily routine. Eagerly waiting for all the next parts of this series........... Good Luck!!!
Great Video! Thanks!
brilliant, thank you, Kapil - South Africa
Great tutorial!
Awesome video
I love this channel! Are you going to focus strictly on SQL Server in the future or do you plan on creating content for MySQL/Postgresql as well?
cool introduction 👍
Nice vid, well PLANned and EXECUTEd ;-)
I tried to use the showplan_all on/off but it won´t work. Do you have to import something into your sql server? or why is it that i cant use it?
hey Bert (or anyone else that knows :)) - at 6:50 you talk about viewing the cach plans by looking at the 'DMV' called dm exec etc etc. What is a DMV in this context? Just trying to understand what those commands are... where do they come from? What is this 'DMV' that you refer to?
Wanna play a drinking game you'll never survive? Take a drink every time he says the word, "actual".
Thank you for the info, is it an issue if the execution plans are never reused? We have an EHR data base and the execution plans are showing 0 for reuse. Just wondering if that's normal.
Thanks good video
Am I the only one who noticed the Polish eagle sticker on his laptop? Where do I get one?
what camera u used to glow ur face
How come you have a Polish flag on your laptop?
🌷🌷🌷🌷
Huh, I got kicked out of Fat Heads once.
"Sql Server is a declarative language"? You're confused kid. SQL is an ANSI standard language developed by IBM like 3 decades before you were even born. Sql Server is a RDBMS. That stands for Relational Database Management System. Another concept that came long before your time. And again, Microsoft *DID NOT INVENT IT.* Microsoft developed their RDBMS kinda late in the game, long after DB2, Ingres, Oracle and others were already mature platforms. Not saying its not a good product, it is. It uses Transact SQL as a language that includes not only standard SQL commands, but also many other commands that make working with SQL and administering a database easier and richer. Have a nice day kid.
No dude, the XML version of the EP is so you can share the plan with other people. Are you new to the IT game? Are you like 16 or something? Sorry you're probably 19 now.
bla bla bla