Printed 2017/08/17 11:21AM

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

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.