Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019, we now have the ability to do the same functionality on the actual create index process. The ability to pause and then resume index build processes is invaluable to most organizations. Previously, most DBAs had to carefully orchestrate index operations around daily activities, work loads, and reporting needs. These newer features help to elevate a lot of these scheduling issues that DBAs routinely encounter.