What is blocking and how would you troubleshoot it?
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
Define self join?
How do you troubleshoot errors in a SQL Server Agent Job?
Explain primary key and foreign key constraints?
How do I find my localdb version?
What is a view in sql?
How to list all columns in a table using odbc_columns()?
How will you make an attribute not process? : sql server analysis services, ssas
Does full backup break log chain?
How many categories of functions based their return modes?
How to turn on the mssql api module in php?
What is a print index?
What are date and time data types in ms sql server?
How to use the inserted and deleted pseudo tables?
What is cube dimension? : sql server analysis services, ssas
How to use group functions in the select clause in ms sql server?