Common Query Plan Patterns: Introduction

Muy Bueno


I’m writing this series because as interesting as single operators can be, you rarely run into interesting query plans that are a single operator. I don’t know exactly how many posts this will end up being. I have a list of about 15 things that I’d like to write about.

Anyway, I’d been thinking about something like this for a while, because being able to understand  which part of a query generates which part of a query plan can help you focus in on what you need to work on. It’s also helpful to understand how different aspects of your database design and written queries might manifest in query plans.

You know, for performance.

Anyway, I hope you enjoy it. This post will be remarkably empty on first read, but will populate over time.

Thanks for reading!

Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.



2 thoughts on “Common Query Plan Patterns: Introduction

  1. Sounds great! This is something you can hardly find in any blog posts / presentations / webinars etc. Maybe, there is a reason for it. Maybe, I am just following wrong sources or I am bad at googeling…Anyway, good luck and I’m so looking forward to it.

    1. They’re hard posts to write. I made a list, and while writing them each topic seems to end up as multiple posts. I understand why no one is jumping at the idea.

Comments are closed.