Denesh Naidoo (7/3/2013)
Running SQL Server 2008 R2 Enterprise Edition. The environment runs 24/7
Had a normal indexing job...but this was obviously being blocked by user processes.
Changed to Online Indexing...but i'm still having this issue which I don't understand why.
Any assistance is greatly appreciated.
Online index rebuilds still require a schema lock. Can you inspect the type of lock? What type of statement is blocking the rebuild?
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato