Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8066 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
Find nth lowest salary or get nth lowest salary?
Explain different types of lock modes in sql server 2000?
How sql server enhances scalability of the database system?
What is the difference between stored procedure and user defined functions?
What command do we use to rename a db, a table and a column?
What is the report builder?
What are different backups available in sql server?
What are points to remember while using the fillfactor argument?
Explain the steps needed to create a scheduled job?
Explain what are magic tables in sql server?
Which is better statement or preparedstatement?
What are extended events in sql server?
What's the information that can be stored inside a bit column?
Is there any difference between primary key and unique with the not null condition?
What is the difference between char, varchar and nvarchar?
