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
Nested Loops Joins and Performance Spools Paul White on performance spools, and how they can be used by the optimizer to reduce the estimated cost of nested loops joins. Paul White ◆ September 25, 2019 2
