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
NULL complexities – Part 1 Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server. Itzik Ben-Gan ◆ December 11, 2019 8
Filtered Indexes and Forced Parameterization (redux) Aaron Bertrand shows a simple way to keep your filtered indexes effective even under forced parameterization. Aaron Bertrand ◆ December 3, 2019 7
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
Thoughts on SQL Server 2019 Editions Aaron Bertrand shares his thoughts about the upcoming SQL Server 2019 release and, specifically, edition-specific features. Aaron Bertrand ◆ November 1, 2019 1
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