RCSI/SI doesn’t work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of my customers. One big part of this workshop was also the new Optimistic Concurrency model that SQL Server offers us since the inception of SQL Server 2005. Since SQL Server 2005 we have the READ COMMITTED SNAPSHOT ISOLATION level (RCSI) …
RCSI/SI doesn’t work with rows larger than 8046 bytes + read more
