Inconsistent analysis with clustered indexes?Commented on: 3 years ago
(September 19, 2011)
Nice example and explanation! There is a tiny typo: after updating in connection 3, you would commit in connection 1, not connection 2 (which is blocked and waiting on conn 1 to commit).
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.