This is the second part of the series. Hopefully you are all caught up on Part 1. If not, you can see that here. Part 2 is about Actual Execution Plans. I have the (slightly edited for garbled words) transcript below for those who prefer to read, with references to places in the video. Otherwise, watch the video and let me know what you think.

I'm very excited for this because I've wanted to put something together about this topic for a long time. What inspired me is that I've really come to appreciate that there's different pieces of information collected with the execution plan itself depending on where I get the plan from. Understanding what's collected, where, and why can help make a difference when trying to troubleshoot and performance tune.

In my previous blogpost (Click here to read) I wrote about a query that just wouldn't go parallel. This sparked some discussion and interest from a few people who were very kind and helpful with their...

It's the final video of the 3 part series. Hopefully you have watched (or read) Parts 1 & 2. This third video is about DMVs and Query Store. We'll bring everything back together at the end. The (slightly edited for garbled words) transcript is at the end for those who prefer to read, with references to where in the video you can find the demos I'm talking about.

queryDiff is a web application for comparing SQL query plans, providing visual, statistical, and text-based diffs. It supports the MS-SQL server dialect and allows users to upload files or paste text for analysis. The app is designed to help users identify differences in query execution plans, making it easier to optimize SQL queries and understand performance implications. There are plans to support other SQL dialects in the future.