October 1, 2021 at 12:00 am
Comments posted to this topic are about the item The Record That Never Existed (as a committed row)
October 2, 2021 at 1:24 pm
Based on https://docs.microsoft.com/en-us/archive/blogs/craigfr/query-plans-and-read-committed-isolation-level by Craig Freedman of Microsoft.
It would have been nice if you had acknowledged that.
Only committed data is read in the example shown.
There is no guarantee under locking read committed isolation that the committed data read at different times won't have changed.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
October 3, 2021 at 2:30 pm
Thanks Paul for your comment. It's true that only committed data is read, no doubt. My intention was only to underline that the SELECT "got only a subset of the planned updates" by the other transaction inside a single transaction. Only this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply