Explanation: If schema_name is NULL, the default schema of the current user is used. 9. sp_estimate_data_compression_savings requires ______ permission on the table.
A. UPDATE
B. SELECT
C. DELETE
D. None of the mentioned
Answer:A
Explanation: If schema_name is NULL, the default schema of the current user is used. 9. sp_estimate_data_compression_savings requires ______ permission on the table.
A. UPDATE B. SELECT C. DELETE D. None of the mentioned
Explanation:Use sp_estimate_data_compression_savings to estimate the savings that can occur when you enable a table or partition for row or page compression. 10. Which of the following query estimates the size of the Production.WorkOrderRouting table if it is compressed by using ROW compression ?