Data compression, one of the many features introduced in SQL Server 2008, can help decrease the size of a database on disk, by reducing wasted space and eliminating duplicate data. Additionally, data compression can increase the speed of queries that perform high amounts of I/O, to and from disk, since each I/O operation can read or write more data.
Numbers will always vary from one environment to the next but, at my organization, the strategic deployment of data compression cut our overall database size on disk by nearly 50% and the execution time for key queries and processes by an average of 30%.
Nevertheless, DBAs must not take lightly the decision of when and where to deploy data compression; while ...
No credit card required