The tenth and final part of my series on Craig Freedman’s SQL Server query-processing blog (part 9, 2008, is here). Craig’s posting slowed down in 2009 — seven more articles followed, heavy on I/O performance and hint pitfalls, before the…

Part 9 of my series on Craig Freedman’s SQL Server query-processing blog (part 8, 2007, is here). In 2008 Craig published 16 articles: deeper update internals, the ranking functions, a three-part warning about conversions, the reworked partitioning in SQL Server…

Part 8 of my series on Craig Freedman’s SQL Server query-processing blog (part 7, December 2006, is here). After a writing pause — he was busy contributing to Kalen Delaney’s Inside SQL Server 2005: Query Tuning and Optimization — Craig…

Part 7 of my series on Craig Freedman’s SQL Server query-processing blog (part 6, November 2006, is here). December 2006 brought a single article before a longer writing break — but it’s a gem about optimizer internals, and it answers…

Part 6 of my series on Craig Freedman’s SQL Server query-processing blog (part 5, October 2006, is here). November 2006 puts the exchange operator from last month to work: how scans, nested loops joins and hash joins actually run in…

Part 5 of my series on Craig Freedman’s SQL Server query-processing blog (part 4, September 2006, is here). October 2006 wraps up the subquery story with decorrelation, answers a reader question about OR-predicates and indexes, and kicks off the parallelism…

Part 4 of my series on Craig Freedman’s SQL Server query-processing blog (part 3, August 2006, is here). September 2006 is aggregation month: how GROUP BY, DISTINCT and the aggregate functions actually execute, plus a closer look at scalar subqueries…

Part 3 of my series on Craig Freedman’s classic SQL Server query-processing blog (part 2, July 2006, is here). August 2006 was join month: the two remaining physical join operators, a summary that pits all three against each other, and…

This is part 2 of my series on Craig Freedman’s classic SQL Server query-processing blog (part 1, June 2006, is here). In July 2006 Craig published four articles that finish the story of indexes and access paths, and then open…