1.

Which of the following code is used to enable compression on a table?

A. EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ;
B. EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ;
C. EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ;
D. EXEC sp_estimate_compression 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ;
Answer» B. EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ;


Discussion

No Comment Found