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
