Tag Archives: SQL

Enabling Compression on a Large SQL Server Table With Zero Downtime

Typically with a table in SQL Server if you want to enable compression, you’d have to duplicate the table and have downtime while you get the 2 tables in sync and swap them over. Using computed columns, you can compress a table with no downtime, and without requiring any extra database or disk space.
Continue reading Enabling Compression on a Large SQL Server Table With Zero Downtime