GilaMonster (1/10/2013)
opc.three (1/10/2013)
. Online index rebuilds do not block anything regardless of the isolation level.Kinda...
Online index rebuilds are mostly online. They take a short-lived IX lock at the beginning (which blocks writers) and a short-lived Sch-M lock at the end (which blocks everything)
I guess "Mostly Online Index Rebuilds" wasn't acceptable to marketting
I know about those locks but took the question to mean "blocking during the rebuild." The locks are very short lived and are an even trade between isolation levels. They effectively pause necessary operations on the table to ensure stability at the initiation of the index rebuild and at the end when the new index is swapped into the old indexes place.
"Mostly Online" feels like ~60%. I'd submit "Near Online", it feels closer to 99% 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato