In this article we are going to configure Data compression in SQL Server 2008. Configuring data compression is very easy with just an couple of steps. The steps are below
- Estimate the Compression Ratio (Optional)
- Configure Data Compression
Monthly Archives: November 2009
Configuring Data Compression – SQL Server 2008 – Part 4
Posted by Vidhya Sagar
on November 28, 2009
No comments
Types of Data Compression – SQL Server 2008 – Part 3
Posted by Vidhya Sagar
on November 27, 2009
No comments
In my previous article we have seen the need for compression, goal of compression etc. In this article we are going to discuss the types of compression supported in SQL Server 2008. There are two types of compression supported and they are
- Row Level Compression and
- Page Level Compression
Lets discuss on each compression type
Data Compression – SQL Server 2008 – Part 2
Posted by Vidhya Sagar
on November 10, 2009
2 comments
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. Lets discuss on this one by one