Compressed Microsoft SQL Server Backups by Default

Learn how to create default database compression for your SQL Server databases.

Compression estimates

The script estimate compression benefits per each object in the database for which the page compression has not been implemented.

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.

Compression and its Effects on Performance

Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

SQL Server Stored Procedure to Compress Non Partitioned Tables

My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008

Estimate compression for all tables and indexes with both Row and Page

This will log output of estimate compression for both PAGE and ROW for all tables and indexes

Data Compression

This script is used to compress tables and indexes. It is designed for page compression on all. Just a little ditty to help with our EDW storage and processing.

Compress All Objects

Creates compression scripts for all objects in all databases in the instance.

Compression