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
