Which Of The Following Code Is Used To Enable Compression On A #857
Which of the following code is used to enable compression on a table?
This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Performance Tuning and Optimization - Data Compression - Quiz No.1.
Which of the following code is used to enable compression on a table?
EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; ALTER TABLE Production.TransactionHistory REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = ROW);
EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; ALTER TABLE Production.TransactionHistory REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = ROW);
EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; ALTER TABLE Production.TransactionHistory BUILD PARTITION = ALL WITH (DATA_COMPRESSION = ROW);
EXEC sp_estimate_compression 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; ALTER TABLE Production.TransactionHistory REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = ROW);
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes