Cool Tips‎ > ‎

Data/Database Compression

 

Title

Description

Applicability

 

Shring DB Log File    

 

While not strictly a compression subject, it does involve making things smaller.

 

2000, 2005, 2008, 2008R2, 2012

 

 

Compress all Tables and Indexes    

Generate scripts to compress all tables and indexes in a database.  Filters can be applied to schema, table and index names.

 

2000, 2005, 2008, 2008R2, 2012

 

List uncompressed tables and indexes

Lists all tables and indexes in a DB not compressed with the specified option.  Also includes the code to compress/change them.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

 

 

 

Comments