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?
Update:
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)