What is blocking and how would you troubleshoot it?
- 2 Answers
- 4937 Views
- 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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is temporary table in sql server? Why we use temp table?
What is indexing explain it with an example?
What are the different editions available in sql server 2000?
Why is sql server log file full?
Why do we partition data?
Please illustrate physical database architecture? : SQL Server Architecture
Tell me what are the advantages of using stored procedures?
List some major differences between triggers and stored procedures?
What's the information that can be stored inside a bit column?
What are indexes in ms sql server?
What do you mean by 'normalization'?
Is a primary key unique?
How to write a query with a right outer join in ms sql server?
What is the purpose of self join?
Can we install sql server 2016 on windows 7?
