Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Data Compression Rss

Search for any content tagged data 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 5 of 5   
 

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 | 918 reads

Data compression applied

It shows you the compression state of all indexes/tables of a database.  Read more...
Rating: |  Discuss |   Briefcase | 1,057 reads

Compress tables

It compresses all the tables/indexes in a database, a specific one or all the objects inside a database schema.  Read more...
Rating: |  Discuss |   Briefcase | 1,799 reads

Scripts for Full DB Compression at partition level

Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.   Read more...
By Jay Rajgor 2009/11/18 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 1,036 reads

SQL 2008 : Uncompressed Objects Procedure

A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.   Read more...
By Richard Doering 2010/12/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 689 reads
   Items 1 to 5 of 5