From Dev.to
Safely Running Long-Running Index Operations in SQL Server
Creating or rebuilding an index on a large, actively used table is not merely a schema change. It is a production operation that can consume significant CPU, I/O, transaction log, and storage resource...