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.
Bạn đang xem 18. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC