In SQL 2014, new option WAIT_AT_LOW_PRIORITY has been introduce to help manage the operation.
- MAX_DURATION: How long the session needs to wait un the low priority
- ABORT_AFTER_WAIT: What happen after the MAX_DURATION
- NONE: Default. continue to wait
- SELF: Terminate the DDL ( itself)
- BLOCKER: Terminate the blocking process
Here is the sample syntax for Index rebuild.
Here is the sample syntax for switching partition.