The SORT_IN_TEMPDB = ON option isn't supported for resumable index operations. The DDL command with RESUMABLE = ON can't be executed inside an explicit transaction. You cannot create an index using a ...

G. Moving tempdb to a new location The following example moves tempdb from its current location on the disk to another disk location. Because tempdb is re-created each time the MSSQLSERVER service is ...