Get a Better Understanding of How Queries Execute


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

a month behind) and came across a link to a new blog by Craig Freedman, a member of Microsoft's SQL Server team.

If you care about understanding how queries execute and, therefore, how

better to tune them, this is a blog that'll likely help though it's relatively new.  Mr. Freedman indicated his reason

for starting the blog in his first blog post:

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.

You can read more here:

Craig Freedman's WebLog

Technorati Tags: |