Matt Whitfield (9/15/2009)

---

kjs714 (9/15/2009)

---

WITH (ROWLOCK) is only nominally respected. After a certain number of locks, escalation will be attempted regardless of that hint. The lock escalation article in BOL gives...

Matt Whitfield (9/15/2009)

---

kjs714 (9/15/2009)

---

In the sample, you are using a batchsize of 10,000. This will end up causing a table lock unless the escalation gets blocked by other processes. If...

In the sample, you are using a batchsize of 10,000. This will end up causing a table lock unless the escalation gets blocked by other processes. If table locks must...

Using the nested scope does not work as can be demonstrated with this modified script:

set lock_timeout 100;

select @@lock_timeout

declare @value1 int

SET @value1 = 0

declare @STR char(100)

set @STR...