PasteThePlan Update: See the Most Recently Pasted Plans

Just another terrifying query
Just another terrifying query lets you paste in execution plans and get a link to share them with other people.

In our company chat room, we get an alert whenever a new plan comes in, and I’m not ashamed to admit that we’re geeky enough that we usually jump straight into it and start poking around. We actually get excited to see what other people are working on.

We figured you might be, too, so here’s a page with the 20 most recently pasted plans.

Also, we’ve been kinda obsessive with Eric Larsen’s excellent drawings of the execution plan operators. Here’s a high-resolution copy you can use for desktop wallpaper, and a crazy-high-res copy if you’d like to make it a laptop or tablet skin. (I’ve already got ’em for my laptop and iPad – I highly recommend

Previous Post
Searching Strings in SQL Server is Expensive
Next Post
MAX Data Types Do WHAT?

6 Comments. Leave new

  • The crazy-hi-res copy is causing an error. Log-in required

  • I wonder if there is any way to use this info to gather a “top 10 list of bad practices that make your plans worse” or something. Might be kind of hard to parse out something like that.

  • hi-res image not working, getting 404 error

  • Kevin Marshbank
    October 19, 2016 11:23 am

    Ooh, I don’t know if I can look at these queries too often. I want to fix them and there’s so many of them to fix! I want to say to the coder, as a weak reference to Anigo Montoya, “I don’t think this query is giving you what you think it is.”
    …great work Ozar team…great work!

  • Laurens Bakker
    October 20, 2016 4:27 am

    I’ve been putsing around the internet trying to find if there’s a way to get SSMS to use these icons.
    No luck so far. Don’t think it’s possible without some proper hacking. Then again, SSMS might just store the icons somewhere in plain sight on some obscure file path…


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.