SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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: | | | | |

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


No comments.

Leave a Comment

Please register or log in to leave a comment.