• subscribe
February 22, 2006 12:00 AM

Compression Basics

SQL Server Pro
InstantDoc ID #49066

Compression routines look for repeating data patterns in files, then replace the patterns with shorter-bit patterns called tokens. Files that contain many repeating bits benefit the most from compression. For example, with compression, you can substantially reduce the size of most bitmap files and Word documents. But JPEG files are already compressed, so there's little or no benefit in trying to shrink the file size further.

You can choose from many compression algorithms. Both GZip and the popular Zip format are based on the widely used DEFLATE algorithm. Generally speaking, the greater the degree of compression you achieve, the longer it take to compress and decompress the data. So, compressing and decompressing frequently accessed data might require too much overhead and time for your needs.

You can perform compression and decompression on the server, the client, or the middle tier. Server-based compression can greatly reduce your storage requirements. But if your clients have excess capacity, having the client perform the compression and decompression makes sense—particularly if the client and server are connected by a slow or bandwidth-constrained network.



ARTICLE TOOLS

Comments
  • Bill
    4 years ago
    May 29, 2008

    This article was too basic. I don't want super-complex articles, but I do want code samples and explicit instructions for how to deploy CLR based UDF's onto the server.

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...