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

Articles with tag Data Compression Rss

Search for any content tagged data compression

   Items 1 to 9 of 9   
 

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,824 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,522 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 | 149 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,662 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,383 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,145 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,313 reads

Data Compression in SQL Server 2005 (Believe it !!)

That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.  Read more...
By Additional Articles 2008/03/18 | Source: SQL Community | Category: sql server 2005
Rating:  Rate this |   Briefcase | 3,789 reads
   Items 1 to 9 of 9