What are the Types of data compression available in SQL Server?

Data compression in SQL Server
There are two types of Data compression SQL Server supports.
1-      Row compression
      SQL server engine performs Row Compression by changing the data storage format, it changes fixed length of different data types into variable length format by eliminating the spaces. More detail can be found in  below MSDN link.
2-      Page compression
      Page compression is actually combination of row compression as well as prefix and dictionary compression. More detail about page compression can be found in below article
There is great article from Microsoft to learn about both types of compression in SQL server. Below is the link to MSDN article which explains SQL Server compression in great detail.

1 comment:

  1. I think there is a need to provide some information about the prospects of SQL alongwith SOAP.Apart from this I really feel one needs to imply them as well.

    SQL Server Load Soap Api