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
Explanation:The sort merge component of the Database Engine starts with the first page of each sort run, finds the lowest key in all the pages, and passes that leaf row to the index create component. 3. Which of the following rebuilds the IX_Employee_OrganizationLevel_OrganizationNode index with a fill factor of 80 on the HumanResources.Employee table ?