While following BrentOzar's "How Much is Offline During an Index Rebuild?" I was curious to run:
SELECT Quantity FROM [Production].[TransactionHistory] WITH(NOLOCK)
while executing a rebuild from mentioned article and observe that it is being delayed until index rebuild finished
What is blocking
SELECT ... WITH(NO LOCK) and how to avoid it?
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)