Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 5466 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 is a partition key?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is a full text index?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to disable triggers using "disable trigger"?
What do you understand by recursive stored procedures?
When should you use an instead of trigger?
can we have a nested transaction? : Sql server database administration
What is the current limitation of the size of SQL Azure DB?
how many type of indexing in database?
What is the difference between deallocate cursor and close cursor?
What you can do to delete a table without the delete trigger firing?
How to connect to SQL Azure Database by using sqlcmd?
Is it possible to update the views? If yes, how, if not, why?
What is use of except clause? How does it differ from not in clause?
