What is the significance of
SORT_IN_TEMPDB when working with indexes on a table of significant size (20GB plus)?
Where else does sorting take place?
The options are -
What it does is instead of utilizing the target database to do the intermediate sorts for creating and rebuilding the index, it uses