What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 5003 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / wazid ali
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What does COMMIT command do?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What does asynchronous call backs means?
What is the difference between stored procedure and functions?
What is Extended user-defined?
What is application role in sql server database security? : sql server security
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Explain atomicity?
How many types of objects are there?
Explain the collation?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How do I create an extended event in sql server?
What are the 7 disadvantages to a manual system?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is openxml in sql server?
