SQL Plan Archives - SQLPerformance.com

Scalar UDF Inlining in SQL Server 2019

Aaron Bertrand introduces Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.

Aaron Bertrand ◆ January 22, 2019

6

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

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

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

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

Optimization Thresholds – Grouping and Aggregating Data, Part 1

In his first SQLPerformance post, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.

Itzik Ben-Gan ◆ April 10, 2018

6

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