DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

Our Sponsors

$4.95/month – NO Long Term Contracts & NO Setup Fee!

The Lounge

12
shouts

Shout it

Data Compression – SQL Server 2008 – Part 2

published 125 days, 1 hour, 22 minutes ago posted by

sqlarticles 125 days, 8 hours ago

Data Compression – SQL Server 2008 – Part 2

In Part1 article I’ve described the need for compression in SQL Server and also gave a brief on Compression enhancement overview. As a next step, in this article I’m going to describe the existing compression techniques, overview of basic compression techniques and goal of compression. Now the questions hits your mind is, why do we need to know the basic techniques? First we need to understand the basic compression techniques available and how it works, this will be the base to understand the compression technique used in SQL Server.