Troubleshooting SQL Server Execution Plans

Sdílet
Vložit
  • čas přidán 25. 07. 2024
  • In this final video of my Execution Plan Series, I share my step by step process for how I troubleshoot poor query performance by using execution plans.
    Check out the rest of the series here: • How To Read SQL Server...
    Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBer...
    Read the related blog post for this episode:
    bertwagner.com/2019/08/27/how...
    Follow me on Twitter:
    / bertwagner
  • Věda a technologie

Komentáře • 18

  • @tripgunn5549
    @tripgunn5549 Před 11 měsíci +5

    I know this is 3 years old and I figured it out.. but would be nice if all 5 video titles indicated their order in the series and the playlist was ordered.
    Great series though, thank you.

  • @arthurmedeiros5388
    @arthurmedeiros5388 Před rokem +1

    Thanks Bert! I’m watching the series for the execution plan and they are really useful

  • @997Pancakes
    @997Pancakes Před 5 měsíci +1

    These videos are gold. Thank you for making them.

  • @benhughes891
    @benhughes891 Před 4 lety +2

    Great video - I'm currently a Junior DBA going through my promotion. This really helped cement some grey areas for me. Thanks!

  • @zanonilabuschagne7628
    @zanonilabuschagne7628 Před 4 lety

    Very pragmatic video, thanks Bert!! A lesson "senior" developers have learned, that ties in with your comment regarding "knowing the system", is "everything is there for a reason"... I've seen juniors come in and rewrite huge chunks of code because the current code "looked wrong", and in the end, they achieved naught. I loved this vid, thanks!!!
    If I may request something for the future... Trace flags. There's just so many, and knowing which ones are really useful would help a lot.

  • @jonkumbi6936
    @jonkumbi6936 Před 4 lety

    Your quick explanation videos are helping me learn and apply these concepts to my new career , I thank you.

  • @oilenrock07
    @oilenrock07 Před 4 lety +1

    You got a new subscriber man! Thanks for helping the community. Keep it up!

  • @craigstriz
    @craigstriz Před 4 lety +1

    Great stuff, glad that I found you!

  • @ramin3809
    @ramin3809 Před 4 lety +1

    Thank you Bret! Awesome content !!

  • @akensturgeon
    @akensturgeon Před 4 lety

    As always Bert, thank you very much.

  • @stamford4education42
    @stamford4education42 Před 2 lety

    Thanks Bert!! Very helpful....

  • @gonggongye
    @gonggongye Před 4 lety

    Thanks for teaching!

  • @TheTruthSpeaker0
    @TheTruthSpeaker0 Před 2 lety

    Thanks a lot Bert!

  • @shakedmaman8267
    @shakedmaman8267 Před 4 lety

    hey bert, great videos!
    what about distinct vs group by?
    can you talk about more functions for performance issues?
    thanks :)
    *go liverpool!!!!*

  • @bblair2010
    @bblair2010 Před rokem

    Thank you!

  • @uruttubake1502
    @uruttubake1502 Před 2 lety

    Hi msy I know what is a explain plan in sql

  • @peersahabnizami1479
    @peersahabnizami1479 Před 17 dny

    Found just stories in all videos. normally we watch video tutorials to understand practical stuff otherwise theory we can read from some web page(s).

  • @2040ashish
    @2040ashish Před 2 lety +1

    Too much theory and no practical my friend !!