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
Strongly Type Those Table-Valued Parameters Jonathan Kehayias shows a simple fix to C# code that can improve performance and throughput of workloads using table-valued parameters. Jonathan Kehayias ◆ January 22, 2020 4
SQL Server 2019 Cumulative Update #1 SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23. Aaron Bertrand ◆ January 10, 2020 0
NULL Complexities – Part 2 Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs including most people's nemesis, the MERGE statement. Itzik Ben-Gan ◆ January 8, 2020 0
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
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
