This script creates scripts to compress all tables and indexes in a database.   Read more...

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...

Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.  Read more...

We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.   Read more...

ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not  Read more...

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...