Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

K. Brian Kelley - Databases, Infrastructure, and Security

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

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.