SQL Server MCQs - CSE MCQs Questions and Answers

Home / CSE MCQs / SQL Server MCQs :: Discussion

To remove archival compression and restore the data to columnstore compression :

Use ALTER TABLE

Use ALTER COLUMN

Use ALTER DATABASE

All of the mentioned

Answer : Option A

Explanation :

use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.

Be The First To Comment

Comments

Name