In the past you always tried to make queries faster by starting joining with the smallest table and end with the largest one, or visa versa, whatever you did.. you never got it very fast.. now lets take a closer…
I must admit, I have done it very often, encapsulate business logic in a function and use it in a select as this example of Erik Darling shows (this is from his Plan Cache Liars series, using sp_BlitzCache). As a…
Erik Darling has created a plugin/skill to analyze execution plans. (see: erikdarlingdata/claude-plugins: Claude Code plugins from Erik Darling Data ) well, lets use it in a convenient way by using the QueryStore and create an Actual plan and feed that…
My friend Erik Darling posted a video on Youtube ( (3) New Claude Plugin For SQL Server Query Plan Analysis – YouTube ) where he showed how to work with a Skill to analyze queryplan. “Two commands to install:/plugin marketplace…
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…
