A partitioned columnstore with no downtime on Standard edition
Compressing and partitioning a 385 million row table written continuously, on SQL Server 2022 Standard: new table built alongside, copy trigger, a partition boundary for the day, a 2.2 second cutover, and what went wrong.
Categories:
21 minute read