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