wikidba.net
Reducing BLOCKING and DEADLOCKING issues
As we know blocking occurs when one SPID holds a lock on a specific resource and a second SPID attempts to acquire a conflicting lock type on the same resource. Typically, the time frame for which …