What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4564 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
How to drop an existing user defined function in ms sql server?
explain different types of cursors? : Sql server database administration
What is explicit cursors?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Which sql server table is used to hold the stored procedure scripts?
What stored procedure would you use to view lock information?
What are the requirements for sql server 2016?
Mention the differences between sql server and mysql.
List out different types of normalizations in sql server and explain each of them?
What’s the use of custom fields in report?
Do you know what is normalization of database? What are its benefits?
What are distinctive joins find as a part of sql?
How do I completely remove sql server instance?
do you know how to configure db2 side of the application? : Sql server database administration
What is an indice?
