Share via

Why am I starting this blog?

  • Article

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

  • Anonymous
    June 08, 2006
    How about PIVOT and UNPIVOT, inside out? Thanks!
  • Anonymous
    June 12, 2006
    The comment has been removed
  • Anonymous
    June 21, 2006
    I'd like to see a discussion of some of the more "obscure" elements in the showpkan (such as RID lookup).
  • Anonymous
    June 26, 2006
    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.
  • Anonymous
    July 14, 2006
    I was catching up on my blog reading (unfortunately, in some cases I'm
    a month behind) and came across...