How soft deletes can slow ghost record growth in Availability Groups
In this tip, I show how soft deletes and a filtered index can help minimize the cost of ghost records in an Availability Group.
Monthly Archive: January 2020
A minor office reorg – part 2
I add some details about phase 2 of my home office changes.
A minor office reorg – part 1
I detail my home office setup, much of the gear in it, and show the progress of a minor renovation – a new standing desk and improved backlighting.
T-SQL Tuesday #122 : Imposter Syndrome
For this month's T-SQL Tuesday, I talk a little bit about how I make my imposter syndrome feel less like imposter syndrome.
SQL Server 2019 Cumulative Update #1
SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
Fun with (columnstore) compression on a very large table – part 2
I continue my series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.
A simple use case for columnstore indexes
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
2019 : Community Influencer of the Year
With another new year comes the recognition of a standout contributor to the SQL Server community. Read on to see 2019's honoree.