Compression Basics

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.

Discuss this Article 1

billmaclean1@gm...
on 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.

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Mike Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators. In fact, for any query with a cost of greater than 5, SQL Server will (by default) use a parallel plan....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.