Keeping Indexes online while reindexing

This will also display the SQL Statement that is the offending blocker.

Online index operations: Online index operations were added as an availability feature in SQL Server 2005. They enable users to continue to query against a table while indexes are built or rebuilt. The main scenario for using this new feature is when you need to make index changes during normal operating hours. The new syntax for using online index operations is the addition of the ONLINE = ON option with the CREATE INDEX, ALTER INDEX, DROP INDEX, and ALTER TABLE operations.
This will also display the SQL Statement that is the offending blocker.

Views – 2340

Leave a Reply