News

Microsoft started down this road with SQL Server 2005 SP2 with the introduction of Vardecimal compression. Previously a column with data type decimal(19,4) would always take up a fixed 19 bytes ...
Because a compressed backup is smaller than an uncompressed backup of the same data, compressing a backup typically requires less device I/O and therefore usually increases backup speed significantly.