Explanation:Enabling compression on a heap is single threaded for an online operation. 6. The data_compression and data_compression_desc columns include :
A. COLUMNSTOREARCHIVE
B. COLUMNSTORE_ARCH
C. COLUMNSTORE
D. None of the mentioned
Answer:A
Explanation:Enabling compression on a heap is single threaded for an online operation. 6. The data_compression and data_compression_desc columns include :
A. COLUMNSTOREARCHIVE B. COLUMNSTORE_ARCH C. COLUMNSTORE D. None of the mentioned
Explanation: The type and type_desc columns include CLUSTERED COLUMNSTORE and NONCLUSTERED COLUMNSTORE. 7. Which of the following code is used to enable compression on a table ?