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

Content with tag Row Compression Rss

   Items 1 to 6 of 6   
 

Estimating Vardecimal

By Steve Jones 2016/04/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 573 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 | 603 reads

A Collaborative Approach To Table Compression

A start at identifying and creating TSQL statements for tables that may benefit from compression.   Read more...
By Mike Byrd 2011/01/13 | Source: SQLServerCentral.com | Category: table compression
Rating: |  Discuss |   Briefcase | 4,471 reads

Improving Database Design and Performance Using Compression

This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.  Read more...
By Suresh Maganti 2010/11/18 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 8,586 reads

Page/Row Compression

By Tushar Kanti 2010/09/03 | Category: row compression
Rating: (not yet rated) |  Discuss |   Briefcase | 3,242 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,884 reads
   Items 1 to 6 of 6   
 
Tags
administration (3)    
page compression (3)    
compression (2)    
performance tuning (2)    
compress (1)    
database design (1)    
sql server 2008 (1)    
table compression (1)    
t-sql (1)