Question: what are the different types of database compression introduced in sql server 2008?
Answer: There are two types of data compression available within SQL Server, row-level and page-level. The row-level compression works behind the scenes and converts any fixed length data types into variable length types.