SQL - Re-build all Indexes

Source: Rebuild all indexes online | thiscodeWorks

-- 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  

---

Appendix: Links

• Code
• SQL
• Databases
• SQL Server
• Development

Backlinks:

list from [[SQL - Re-build all Indexes]] AND -"Changelog"