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
I add some details about phase 2 of my home office changes.
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.
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 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
I continue my series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
With another new year comes the recognition of a standout contributor to the SQL Server community. Read on to see 2019's honoree.