Showplan Enhancements for UDFs Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer). Jonathan Kehayias ◆ August 23, 2018 0
Mining Plans : Not just for the plan cache Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database. Erin Stellato ◆ August 16, 2018 0
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