SQLPerformance.com - Page 2 of 32 - SQL Server performance articles curated by SentryOne

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

4

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

3

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

3

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