Learn how to use data compression in SQL Server, what are the benefits and trade-offs, and how to monitor and manage compressed data.

Do not try this at home. SQL Server 2008 Data Compression is an intelligent compression strategy. It saves space and delivers better performance through less IO.

SQL Server’s first attempt at Data Compression actually looks pretty good. As I noted in my beta preview (see “Microsoft’s ‘Katmai’ is filled to the brim”), SQL Server 2008 provides ...

Contribute to B-3Hive/Partitioning development by creating an account on GitHub.

Performing (de)compression in the database will use database server CPU cycles (and MS license SQL Server per core remember) for something that could easily be moved to the application tier, and using ...

Data Compression, PowerShell integration, and Policy-Based Management, not to mention Server Groups, should make a big splash in almost any environment.

The rapid expansion of data volumes in modern applications has intensified the need for efficient methods of storing and retrieving information. Contemporary research in data compression focuses ...

Available as a separately licensed option for Oracle Database 11g Enterprise Edition, Advanced Compression is a way of writing data to disk so that it takes up less space ...

Data Compression is one of my favorite features in SQL Server 2008 because, surprisingly, there does not appear to be a downside. Flick a switch to save storage and improve performance.