Explanation:It is required to create or rebuild an index when tempdb is on a set of disks different from that of the user database. 2. Point out the correct statement :
A. The Database Engine merges the sorted runs of index leaf rows into a single, sorted stream
B. SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types
C. The fill-factor value is a percentage from 1 to 50
D. All of the mentioned
Answer:A
Explanation:It is required to create or rebuild an index when tempdb is on a set of disks different from that of the user database. 2. Point out the correct statement :
A. The Database Engine merges the sorted runs of index leaf rows into a single, sorted stream B. SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types C. The fill-factor value is a percentage from 1 to 50 D. All of the mentioned