YOU ARE CONTEMPLATING USING DATA COMPRESSION ON A TABLE. YOU WOULD...

18. You are contemplating using data compression on a table. You would like to

know how much space this will save. How can you determine the savings?

A. View the table properties

B. Enable compression, then check the table size

C. Use sp_estimate_data_compression_savings

D. Use sp_check_compression

The correct answer is C. sp_estimate_data_compression_savings will help you

determine if the table is worth compressing.

This procedure accepts five parameters.