SQLPerformance.com - Page 2 of 39 - SQL Server performance articles curated by SentryOne

NULL complexities – Part 3, Missing standard features and T-SQL alternatives

Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how to order NULLs.

Itzik Ben-Gan ◆ February 12, 2020

1

Fun with (columnstore) compression on a very large table – part 3

Aaron Bertrand continues his series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.

Aaron Bertrand ◆ February 3, 2020

1

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