PasteThePlan.com

At PasteThePlan.com, you can paste execution plans into your browser, then send a link to someone else to get query advice. It’s useful for online forums, Stack Exchange, and the like. After you paste the plan, you’ve got a new AI Suggestions tab. It sends your query plan (and my custom prompt) up to ChatGPT…

Building PasteThePlan.com: Removing Comments

Last Updated January 28, 2020

PasteThePlan.com We have this PasteThePlan where you can copy/paste the contents of execution plans, and then share the links around the web. You’ve pasted 16,621 plans so far, and I’m always amused to see them continuing to trickle in every day without us actively promoting that tool. It just works, doing its thing quietly. Back…

Updating Paste The Plan to use the Serverless Framework

Last Updated June 14, 2018

Amazon Web Services (AWS), PasteThePlan.com

I just updated PasteThePlan, and the change you’ll notice first is that we’re using the latest version of Justin Pealing’s html-query-plan. It adds missing index hints, yellow bangs for warnings like implicit conversions and no join predicate, and more. Check out this example plan: PasteThePlan, June 2018 Edition Plus variable line widths for different amounts…

Paste The Plan…Now With Comments

Last Updated October 18, 2017

PasteThePlan.com You didn’t ask but we listened: we have added comments to Paste The Plan. We’re always looking for way we can improve the tools that we provide to the community. One of the things we always thought that would be nifty was to add comments to the plans. So while we were finishing up…

PasteThePlan October 2017 Update

Last Updated October 4, 2017

We’re back at it again. We took a bit of time out of our busy schedule to put in a few enhancements into PasteThePlan.com. Here’s some of the highlights: Updated to the latest version of HTML Query Plan. In order to create a graphical query plan we use Justin Pealing’s awesome HTML Query Plan. Recently,…

Lessons Learned From Working in the Clouds

Last Updated October 29, 2016

Architecture, Cloud Computing, PasteThePlan.com

Recently, we released PasteThePlan.com, which runs on top of Amazon Web Services. PasteThePlan.com allows you to share SQL Server query plans with others. Behind the scenes, we’re using DynamoDB (a NoSQL database) for record data and S3 (a file storage service) to store text data. Since we’re a bunch of data freaks, we wanted to make sure…

PasteThePlan Update: See the Most Recently Pasted Plans

Last Updated February 13, 2017

Execution Plans, PasteThePlan.com

Just another terrifying query PasteThePlan.com 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…

PasteThePlan.com Winners and Sample Plans

Last Updated April 9, 2017

Execution Plans, PasteThePlan.com

When we announced PasteThePlan last week, we wondered what kinds of plans you folks would paste in. Six of you won free Everything Bundles: Ajay Dwivedi Samuel Jones Stefan Gabriel Stephan Schon Steve Armistead Vesa Juvonen But rather than stepping through their plans (which are awesome too), I’m going to show a few bits and…

The Open Source Tools of Paste The Plan

Last Updated September 15, 2016

If you couldn’t tell, we’re big fans of open source software. We like it so much that we recently released our First Responder Kit, including sp_Blitz, under the MIT license. So when we were building Paste The Plan, our free tool to share SQL Server execution plans, there was no question that we were going to use…

How We Architected Paste The Plan

Last Updated September 6, 2016

Architecture, PasteThePlan.com

If you’ve ever heard the Away From the Keyboard, a podcast that I co-host with Cecil Phillip, you’ll quickly discover that I love hearing stories about how products are created. Now I get to tell you the story of how Paste The Plan became real and the architecture around it. In a world… Here at Brent Ozar…

Announcing PasteThePlan.com: An Easier Way to Share Execution Plans

Last Updated April 9, 2017