Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8048 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is a traditional network library for sql servers? : Sql server database administration
What is a cache in ssrs?
How many non clustered indexes there can be on table ?
How will you go about resolving deadlocks?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Can you explain the disadvantages/limitation of the cursor?
what information is maintained within the msdb database? : Sql server administration
Why should we go for stored procedures? Why not direct queries?
How to transfer data from a cursor to variables with a "fetch" statement?
Explain what is lock escalation and what is its purpose?
Define indexes?
Can we call stored procedure in view in sql server?
What does it mean to normalize a database and why would you do it?
What number sorts of privileges are accessible in sql?
Why use update_statistics command in sql server?
