Rebuild all indexes online

PHOTO EMBED

Wed Feb 02 2022 21:09:14 GMT+0000 (Coordinated Universal Time)

Saved by @jimbrig #sql

-- rebuild all indexes online
ALTER INDEX ALL ON Table1
REBUILD WITH (ONLINE = ON);   
GO  
-- rebuild single index online
ALTER INDEX IX_IndexName ON Table1
REBUILD WITH (ONLINE = ON);   
GO  
content_copyCOPY

https://gist.github.com/jimbrig/5d91eef57ce1de7d7f799e92d565631d