What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4549 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shyamsri83
When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to insert new line characters into strings?
What are the differences between user defined functions and stored procedures?
Explain about integration services of Microsoft SQL server?
What are the properties of the relational tables?
How do I manually uninstall an instance of sql server 2016?
What is tablesample?
Why use stored procedures in sql server?
What do you mean by tablesample?
What is the SQL?????????????????????????????
Explain the different index configurations a table can have?
What is a unique index?
What are the different authentication modes in sql server? How can it be changed?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
