Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Compression Rss

Search for any content tagged compression

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 8 of 8   
 

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  Read more...
By Doran Mackay 2015/12/10 | Source: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 625 reads

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.  Read more...
By Eric Blake 2015/11/11 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 1,155 reads

Compress All Objects

Creates compression scripts for all objects in all databases in the instance.  Read more...
By Jakob Bindslet 2015/02/19 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 1,583 reads

Compress all Objects

A short compression script that will compress all tables or indexes.  Read more...
By Gregory Ferdinandsen 2013/03/01 | Source: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 709 reads

Compression of all Objects

This script will compress all objects in the database.  Read more...
By Gregory Ferdinandsen 2012/01/26 | Source: SQLServerCentral.com | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 953 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
Rating: |  Discuss |   Briefcase | 1,041 reads

Script to Compress Tables and Indexes

This script creates scripts to compress all tables and indexes in a database.   Read more...
By Jeremy Egbert 2010/01/04 | Source: SQLServerCentral.com | Category: compress
Rating: |  Discuss |   Briefcase | 4,948 reads

Zip Backups and Copy to Secondary (free)

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...
By Jeff Bennett 2009/06/18 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,456 reads
   Items 1 to 8 of 8