Misconception about Online Rebuild Index Operation till SQL 2012

Microsoft Introduces Online Rebuilding Index operation in SQL Server SQL Server 2005 and after that it is available in all SQL Server versions. So the question arises is Online Rebuilding online operation really an online operation. The answer is YES to some extent but when it comes to DDL specific operation during rebuilding of indexes things changes, please follow below link for more details

Misconception about Online Rebuild Index Operation till SQL 2012

 

 

Advertisements