You administer a Microsoft SQL Server 2012 database. The database contains a Product table
created by using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the Product
table.
What should you do?
A.
Convert all indexes to Column Store indexes.
B.
Implement Unicode Compression.
C.
Implement row-level compression.
D.
Implement page-level compression.
Explanation:
http://msdn.microsoft.com/en-us/library/cc280449.aspx
http://msdn.microsoft.com/en-us/library/cc280464.aspx
http://msdn.microsoft.com/en-us/library/cc280576.aspx
http://msdn.microsoft.com/en-us/library/ee240835.aspx
D
One of our visitors not too long ago recommended the following website.
D
Can anyone explain why the page-level compression was selected over row-level compression?
After reading this thread (https://www.sqlservercentral.com/Forums/562395/Row-Compression-vs-Page-compression), I think I now understand. It depends on the datatype of each column and varchar type does not have any effect on row-level compression.