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

Content with tag Data Compression Rss

   Items 1 to 20 of 22    Older >>
 

Data Compression and Snapshot Isolation

Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit  Read more...
By Jeff Reinhard 2014/10/02 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 2,742 reads

Demonstrating the Effects of Using Data Compression in SQL Server

How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.  Read more...
By Additional Articles 2014/03/25 | Source: MSSQLTips.com | Category: data compression
Rating: (not yet rated)  Rate this |   Briefcase | 3,908 reads

Data Compression Objects

By Steve Jones 2013/12/17 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,533 reads

Data Compression

By P Sibi 2013/11/13 | Category: editions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,662 reads

Data compression

By Chirag Patel 2013/01/30 | Category: data compression
Rating: (not yet rated) |  Discuss |   Briefcase | 2,120 reads

Storing E-mail addresses more efficiently in SQL Server - Part 2

In my last tip, I shared some ideas for determining if you should consider breaking up the e-mail addresses you're storing, even putting the domain names in a separate table. I performed storage and timing comparisons for working with 10,000 unique e-mail addresses, but I completely ignored data compression. I wanted to revisit the same test case and apply data compression to the tables and see how that impacted the outcome.  Read more...
By Additional Articles 2012/04/26 | Source: MSSQLTips.com | Category: data compression
Rating: (not yet rated)  Rate this |   Briefcase | 4,550 reads

Data Compression Double Take

A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.  Read more...
By Tony Davis 2012/03/05 | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 170 reads

Data Compression Double Take

A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.  Read more...
By Tony Davis 2012/03/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 152 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

Page Compression in Heaps

By SQLBalls 2011/08/09 | Category: data compression
Rating: (not yet rated) |  Discuss |   Briefcase | 2,016 reads

Data compression applied

It shows you the compression state of all indexes/tables of a database.  Read more...
Rating: |  Discuss |   Briefcase | 1,060 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,814 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 | 691 reads

Experiments with Data Compression in SQL Server 2008

Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...  Read more...
By GlennBerry 2010/02/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,686 reads

Improving Data Compression Fidelity Without Sacrificing Speed

Making it easier to handle huge data sets  Read more...
By Additional Articles 2010/01/18 | Source: Dr. Dobbs | Category: data compression
Rating: (not yet rated)  Rate this |   Briefcase | 2,406 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,045 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 | 691 reads

Data Compression: Strategy, Capacity Planning and Best Practices

The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.  Read more...
By Additional Articles 2009/08/11 | Source: Microsoft MSDN | Category: data compression
Rating:  Rate this |   Briefcase | 2,184 reads

SQL Server 2008 and Data Compression

One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.  Read more...
By Nicholas Cain 2009/01/07 | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 9,332 reads

Data Compression

By Steve Jones 2008/08/06 | Category: data compression
Rating: (not yet rated) |  Discuss |   Briefcase | 3,286 reads
   Items 1 to 20 of 22    Older >>
 
Tags
sql server 2008 (5)    
administration (2)    
database weekly (2)    
editorial (2)    
best practices (1)    
blogs (1)    
capacity planning (1)    
compression (1)    
data types (1)    
data warehousing (1)    
editions (1)    
full database compression (1)    
heaps (1)    
page compression (1)    
query performance (1)    
snapshot isolation (1)    
sql server 2005 (1)