Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8195 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 the difference between truncate and delete commands?
Explain raiserror in sql server?
What is the difference between Clustered and Non-Clustered Index?
Is sql different from sql server?
What kind of problems occurs if we do not implement proper locking strategy?
What is snapshot report?
What is pivot and unpivot?
What is key attribute?
What is a document index?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is nonclustered index with included columns ?
What is instead of dml trigger?
What is table constraint?
What are the dis_advantages of stored procedures, triggers, indexes?
Is it possible to have clustered index on separate drive from original table location?
