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
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 is available, with 10 enhancements. The build number is 14.0.3430.2.
For T-SQL Tuesday #146, I talk about a couple of crazy ideas I had in my head about filtered indexes.
I show how I set up Azure SQL Edge in a Docker container on the new M1 MacBook.
See one way to use a queue table to spread out spiky, ad hoc deletes from a clustered columnstore index.