Tuesday, February 25, 2020

blocking versus deadlocks in T-SQL

This offers that if a resource is blocked by way of being used by one T-SQL statement, a different T-SQL statement will just wait until the resource is freed up. In deadlocks there is more than one resource to be had to do the thing for the two T-SQL requests and one T-SQL statement gets a deadlock on one thing while the other is thus routed to the other actor by default given what it cannot do.

No comments:

Post a Comment