Explanation:Enabling a disabled index can be done using SSMS. 2. Point out the correct statement :
A. When SORT_IN_TEMPDB is set to OFF, the default, the sort runs are stored in the source filegroup.
B. The Database Engine first scans the data pages of the base table to retrieve key values and builds an index leaf row for each data row.
C. When SORT_IN_TEMPDB is set to ON, the default, the sort runs are stored in the destination filegroup.
D. None of the mentioned
Answer:A
Explanation:Enabling a disabled index can be done using SSMS. 2. Point out the correct statement :
A. When SORT_IN_TEMPDB is set to OFF, the default, the sort runs are stored in the source filegroup. B. The Database Engine first scans the data pages of the base table to retrieve key values and builds an index leaf row for each data row. C. When SORT_IN_TEMPDB is set to ON, the default, the sort runs are stored in the destination filegroup. D. None of the mentioned
Explanation:When the internal sort buffers have been filled with leaf index entries, the entries are sorted and written to disk as an intermediate sort run. 3. Which of the following query enables the IX_Employee_OrganizationLevel_OrganizationNode index on the Employee table ?