I’ll admit it, sometimes I’m wrong.
Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations was introduced with SQL Server 2017 however it was limited to only REBUILD operations. With the release of SQL Server 2019, Microsoft has extended that ability to CREATE operations now. Two features that accompany these new abilities, which I consider very versatile, is the ability to specify a maximum degree of parallelism (MAXDOP) or a maximum duration. Both provide database administrators more granular control over their index operations and how much impact they will affect to their production environment.