This is one of those questions that I answered randomly because I wanted to see what the answer was...would have been nice to get a slightly more in-depth explanation. ... )
In fact, I still do not understand, even after reading on it, why it does "escalation"
- "Rowlock" locks the row being updated and (what I think) releases the lock once the update is done.. It loops for the 7500 rows to be updated, locking and unlocking the rows...
So, why and where does the escalation comes from?