Types of Data Compression – SQL Server 2008 – Part 3
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
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
Data Compression – SQL Server 2008 – Part 1
Data compression is an enhanced feature available in SQL Server 2008. Database compression in SQL Server is introduced with SQL Server 2005 SP2 onwards where we have the capability to compress VARDECIMAL data type. This compression works when the actual value is less than the declared value, all the remaining values will be removed there by compressing the empty space. In SQL Server 2008 we have native compression techniques added to reduce the size of your database.
Variable and Assignment enhancements – SQL Server 2008
Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers.
- Declare Statement
- Compound Assignment Operators
- Row Constructors
- Table Valued Parameter (TVP) Lets discuss on this titles one by one
Activity Monitor – SSMS 2008
Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU time etc, this really helps us to know the status of the server immediately.