Question:Which of the following statements are true regarding row and page compression in SQL Server 2008? 

A When a table or index is created, data compression is set to NONE, unless otherwise specified. 
B Nonclustered indexes inherit the compression property of the table. 
C New pages allocated in a heap as part of DML operations will not use PAGE compression until the heap is rebuilt. 
D When you are compressing indexes, leaf-level pages can be compressed with only page compression. 

+ Answer
A C 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description