SQLPerformance.com

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

Reasons to Upgrade to SQL Server 2017

Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose the newer version.

Glenn Berry ◆ April 23, 2018

5

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

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

Row Goals, Part 3: Anti Joins

Continuing his in-depth series on row goals, Paul White explains both why and how they can impact queries involving anti joins.

Paul White ◆ March 7, 2018

0

SQL Server and the Spectre/Meltdown Vulnerabilities

Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected.

Glenn Berry ◆ March 1, 2018

1