Explanation:The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity. 4. Which of the following guideline is considered during column design ?
A. Keep the length of the index key short for non clustered indexes
B. An xml data type can only be a key column only in an XML index
C. Examine column which have composite primary keys
D. None of the mentioned
Answer:A
Explanation:The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity. 4. Which of the following guideline is considered during column design ?
A. Keep the length of the index key short for non clustered indexes B. An xml data type can only be a key column only in an XML index C. Examine column which have composite primary keys D. None of the mentioned
Explanation:QL Server 2012 SP1 introduces a new type of XML index known as a Selective XML Index.This new index can improve querying performance over data stored as XML in SQL Server, allow for much faster indexing of large XML data workloads. 5. Point out the wrong statement :