Answer: Blocking in SQL Server is a scenario where one connection to SQL Server locks one or more records, and a second connection to SQL Server requires a conflicting lock type on the record or records locked by the first connection. This causes the second connection to wait until the first connection releases its locks. By default, a connection will wait an unlimited amount of time for the blocking lock to go away.
Blocking is not the same thing as a deadlock. For more details on SQL Server blocking visit this nice article
http://www.sql-server-performance.com/tips/blocking_p1.aspx
Asked In: Many Interviews |
Alert Moderator