What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
Answer Posted / shyamsri83
When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain external key management in sql server 2008
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is update locks?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How many types of functions are there in sql server?
What part does database design plays a role in performance of an sql server-based application?
How many types of triggers are there?
What are the differences between sql server and mysql.
What are dml triggers and types of dml triggers?
What are the differences between left join and inner join in sql server?
Explain how many types of relationship?
How to find tables without indexes?
When you should use a low fill factor?
Explain transaction server isolation?
What is encryption key?