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

Content with tag Compression Rss

   Items 1 to 18 of 18   
 

Compress All Objects

Creates compression scripts for all objects in all databases in the instance.  Read more...
By Jakob Bindslet 2014/02/11 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 884 reads

Compression

By Igor Micev 2014/01/30 | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 1,872 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 | 686 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 | 923 reads

SQL Server Compressed Backups Disk Space Needs

SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file?  Read more...
By Additional Articles 2011/11/16 | Source: MSSQLTips.com | Category: compression
Rating: (not yet rated)  Rate this |   Briefcase | 2,087 reads

Unicode Compression

By Britt Cluff 2011/07/28 | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 1,991 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,131 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...
By Press Release 2010/10/25 (first published: 2010/10/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
By Gregory Ferdinandsen 2010/08/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,036 reads

SQL Server 2008 Compression

Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.  Read more...
By Jason Shadonix 2010/04/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 7,427 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,161 reads

Decompressing on Compression in SQL Server 2008....

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...
By Robert Pearl 2009/09/02 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,110 reads

Page compression in SQL Server 2008

Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.  Read more...
By Additional Articles 2009/06/29 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,137 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,303 reads

Tuning the Performance of Backup Compression in SQL Server 2008

ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not  Read more...
By Additional Articles 2008/05/12 | Source: MSDN Communities | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 1,813 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,131 reads
   Items 1 to 18 of 18   
 
Tags
sql server 2008 (7)    
backup / restore (6)    
administration (2)    
7zip (1)    
backup / recovery (1)    
blogs (1)    
compress (1)    
compression ratio (1)    
data (1)    
data compression (1)    
disaster recovery (dr) (1)    
disk space (1)    
gzip (1)    
log shipping (1)    
page compression (1)    
performance tuning (1)    
row compression (1)    
sql server 2005 (1)    
sqlservercentral (1)    
storage management (1)    
webinar (1)    
zip (1)