Fun with (columnstore) compression on a very large table – part 1
I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
Monthly Archive: December 2019
Using metadata to troubleshoot metadata
I show how I tried to chase down a very unexpected issue with SQL Server metadata. Spoiler: it didn't end the way I thought it would.
T-SQL Tuesday #121 : Gifts
For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.
Filtered Indexes and Forced Parameterization (redux)
Discover a simple way to keep your filtered indexes effective – even under forced parameterization.
Should we still chunk delete operations?
Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.