SQL Performance Archives - Page 11 of 31

Migrating from AnswerHub to WordPress : A Tale of 10 Technologies

Aaron Bertrand describes the process of migrating nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to its new read-only home on WordPress.

Aaron Bertrand ◆ September 10, 2018

0

Perfect Storm for Upgrading to a Modern Version of SQL Server

Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server – considering not only the platform improvements but also changes to Windows, storage, and hardware.

Glenn Berry ◆ September 4, 2018

1

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

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