[Video] “Actual” Execution Plans Lie for Branching Queries

In which I show why you can’t trust “actual” execution plans for branching stored procedures, and you’re better off using sp_BlitzCache to figure out what branches you need to tune:

Demo code:

This is one of the reasons you won’t catch me using the “Edit Query Text” in query plans during this week’s Mastering Query Tuning class.

Previous Post
Do I Have A Query Problem Or An Index Problem?
Next Post
[Video] Office Hours 2018/7/25 (With Transcriptions)

3 Comments. Leave new

  • Steve Malcolm
    July 27, 2018 11:29 am

    First, I’m impressed to learn that you do these videos in more than a single take.
    Second, I want to register my vote for more champagne fueled instruction sessions.

    Reply
    • Steve – hahaha, thanks. Yeah, it’s really funny – sometimes, the videos work flawlessly on the first take, but some days, not so much. On that day, everything that could go wrong, kept going wrong, heh. Had one perfect take early on, and realized I’d forgotten to start the recording!

      Reply
  • Thank you very much!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}