Category: Articles
-
Configuring Data Compression
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
-
Types of Data Compression
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
In Part1 article Ive described the need for compression in SQL Server and also gave a brief on Compression enhancement overview. As a next step, in this article Im 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…
-
Data Compression
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…
-
SQL Server 2008 MCITP (70-453) Exam
Today Ive written the exam 70-453 (Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008) and Ive cleared the exam. I would like to share the information regarding this exam. While preparation Ive searched for these information but I got very limited information on this, so I think this could be…