Performance Myths: The query result cache Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster. Guest Posts ◆ July 23, 2018 1
Tracking down high CLR_MANUAL_EVENT waits Jonathan Kehayias of SQLskills.com shares his story of an unusual situation with high CLR_MANUAL_EVENT waits and how he resolved it. Jonathan Kehayias ◆ July 18, 2018 2
Optimization Thresholds – Grouping and Aggregating Data, Part 4 In the fourth installment of his series on optimization thresholds, Itzik Ben-Gan looks at how SQL Server applies costs to parallel operations. Itzik Ben-Gan ◆ July 11, 2018 7