Optimization Thresholds – Grouping and Aggregating Data, Part 5 In the conclusion of his series on grouping and aggregation costs, Itzik Ben-Gan reveals some of the math behind seek vs. scan decisions. Itzik Ben-Gan ◆ August 8, 2018 2
Azure SQL Database Performance and Service Tiers Explained Glenn Berry of SQLskills.com describes the different tiers for Azure SQL Database, and what you get for your money in each case. Glenn Berry ◆ August 1, 2018 3
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
Join Elimination: When SQL Server Removes Unnecessary Tables For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server. Guest Posts ◆ June 18, 2018 0
Optimization Thresholds – Grouping and Aggregating Data, Part 3 Itzik Ben-Gan dissects the Hash Match (Aggregate) algorithm in his latest post in a series on SQL Server optimization thresholds. Itzik Ben-Gan ◆ June 13, 2018 10
The Importance of Baselines Tim Radney goes into detail about why baselines are important, and how metrics you collect now can help you solve future problems. Tim Radney ◆ May 24, 2018 2
Optimization Thresholds – Grouping and Aggregating Data, Part 2 Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the calculations behind stream aggregate costing when the data needs to be sorted first. Itzik Ben-Gan ◆ May 9, 2018 6
Automatic Index Management in Azure SQL Database Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management. Erin Stellato ◆ April 5, 2018 5
Dealing with date and time instead of datetime Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance. Rob Farley ◆ March 29, 2018 5
Row Goals, Part 4: The Anti Join Anti Pattern Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti join. Paul White ◆ March 19, 2018 0
