Why am I starting this blog?

About two years ago I presented a talk to a couple of SQL Server user groups where I explained in general terms how SQL Server executes queries.  I explained how to read showplan and how some of the most common operators (such as index scans and seeks, joins, and aggregation) actually work.  I received a lot of positive feedback from these talks and I’ve decided to try to capture some of these topics in this blog.  If you have questions or comments, I’m very interested to hear what you think and what you’d like me to write about and I’ll do my best to respond.

Comments (5)

  1. Xied75 says:

    How about PIVOT and UNPIVOT, inside out? Thanks!

  2. You may find the following paper on PIVOT and UNPIVOT helpful.

    Conor Cunningham, César A. Galindo-Legaria, Goetz Graefe,

    PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS,


  3. pdianne says:

    I’d like to see a discussion of some of the more "obscure" elements in the showpkan (such as RID lookup).

  4. RID Lookup is the SQL Server 2005 replacement for Bookmark Lookup on heaps in SQL Server 2000.  I am planning to write about bookmark lookup soon.  Thanks for the feedback.

  5. Brian Kelley says:

    I was catching up on my blog reading (unfortunately, in some cases I’m

    a month behind) and came across…

Skip to main content