I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.

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.

For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.

Discover a simple way to keep your filtered indexes effective – even under forced parameterization.

Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.