SQL Server 2019 Cumulative Update #15
SQL Server 2019 Cumulative Update #15 is available, with 39 enhancements (35 public). The build number is 15.0.4198.2.
Monthly Archive: January 2022
Just Enable Indirect Checkpoints on All Databases, Please
In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.
SQL Server 2017 Cumulative Update #28
SQL Server 2017 Cumulative Update #28 is available, with 10 enhancements. The build number is 14.0.3430.2.
T-SQL Tuesday #146 : Preconceived Notions
For T-SQL Tuesday #146, I talk about a couple of crazy ideas I had in my head about filtered indexes.
Testing Azure SQL Edge and Docker on the latest MacBooks
I show how I set up Azure SQL Edge in a Docker container on the new M1 MacBook.
Serializing Clustered Columnstore Deletes
See one way to use a queue table to spread out spiky, ad hoc deletes from a clustered columnstore index.