SQL Performance Archives - Page 6 of 31

New Metadata-Only Column Changes in SQL Server 2016

Paul White investigates the new metadata-only column data type changes possible in SQL Server 2016 when using data compression.

Paul White ◆ April 17, 2020

3

Bandwidth-friendly Query Profiling for Azure SQL Database

This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database.

Greg Gonzalez ◆ April 15, 2020

0

Finding Distinct Values Quickly

Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019.

Paul White ◆ March 17, 2020

1

Why Wait Stats Alone Are Not Enough

Tuning SQL Server by looking at waits alone and ignoring resources could be costing you time, money, and performance. Greg Gonzalez explains why.

Greg Gonzalez ◆ January 24, 2020

5

Fun with (columnstore) compression on a very large table – part 2

Aaron Bertrand continues his series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.

Aaron Bertrand ◆ January 7, 2020

0

Fun with (columnstore) compression on a very large table – part 1

Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.

Aaron Bertrand ◆ December 27, 2019

0

The Eager Index Spool and The Optimizer

Paul White looks at the Eager Index Spool execution plan operator, and the optimizer rules capable of adding it into plans.

Paul White ◆ November 22, 2019

0

The Importance of Selecting the Proper Azure VM Size

Tim Radney talks about the performance trade-offs when deciding between various VM sizes in Azure.

Tim Radney ◆ November 18, 2019

0

Row numbers with nondeterministic order

Itzik Ben-Gan discusses the ins and outs of numbering and retrieving rows in a nondeterministic (but explicitly not random) order.

Itzik Ben-Gan ◆ November 13, 2019

13

Analyzing "death by a thousand cuts" workloads

Erin Stellato shows how to analyze patterns in your workload when dealing with many short, resource-intensive queries, a scenario commonly referred to as "death by a thousand cuts."

Erin Stellato ◆ October 29, 2019

1