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
Azure Virtual Machines for SQL Server Usage Glenn Berry describes different types of Azure VMs and explains which might be better suited to your SQL Server workload. Glenn Berry ◆ December 17, 2019 1
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
Understanding Event Loss with Extended Events Jonathan Kehayias describes various ways you can suffer (and prevent) event loss when using Extended Events in SQL Server. Jonathan Kehayias ◆ October 17, 2019 1
Overlooked T-SQL Gems Itzik Ben-Gan discusses lesser-known T-SQL features and some aspects that many of us make assumptions about. Itzik Ben-Gan ◆ October 9, 2019 15
