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
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