As you might have guessed, this feature allows you to pause and resume an index rebuild operation. Rebuilding an index on very large tables requires a lot of system resources and log space. Sometimes, a rebuild operation is still running when you are at the end of the maintenance window. That usually means, you have to cancel the operation and restart it later from the beginning. The same happens in case of a database failover or when you are running out of disk space.
In SQL Server 2017, you can solve these problems so that you can arbitrarily pause and resume index rebuild operations. To see how this feature works, open a connection to an SQL Server 2017 instance in SSMS and create an index in the WideWorldImporters ...
