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

Content with tag Compression Rss

   Items 1 to 20 of 23    Older >>
 

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  Read more...
By Kenneth Igiri 2016/01/18 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 2,698 reads

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 | 575 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,102 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 12,847 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,572 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,572 reads

Compression

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

Unicode Compression

By Britt Cluff 2011/07/28 | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 2,003 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,148 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,911 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,911 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,911 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
Rating: |  Discuss |   Briefcase | 1,038 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,494 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,822 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,305 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,238 reads
   Items 1 to 20 of 23    Older >>
 
Tags
sql server 2008 (7)    
backup and restore (6)    
administration (3)    
data compression (2)    
page compression (2)    
row compression (2)    
7zip (1)    
blogs (1)    
columnstore index (1)    
compress (1)    
compression ratio (1)    
data (1)    
data warehouse (1)    
database settings (1)    
dbcc shrinkfile (1)    
disaster recovery (dr) (1)    
disk space (1)    
gzip (1)    
instance settings (1)    
log shipping (1)    
max degree of parallelism (1)    
optimize for ad hoc workloads (1)    
partitioning (1)    
performance tuning (1)    
recovery model (1)    
sql server 2005 (1)    
sql server 2014 (1)    
sqlservercentral (1)    
storage management (1)    
webinar (1)    
zip (1)