How can your resolve deadlocks?
Answer Posted / sasikala
one way to kill the process which is responsible for dead lock. after this the process can proceed without any problem. after a process completed , the killed process should be created and executed as if nothing has happened. but the killed process might have changed in an data base or some records. it must have changed as before to maintain the consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How important do you consider cursors or while loops for a transactional database?
Name and describe few console utilities for ssrs?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Benefits of Stored Procedures?
What is a heap?
How to query multiple tables jointly?
What is the use of “join” in sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is Sqlpaging in SqlServer 2005 ?
What is the purpose of the master database?
What is an execution plan? How would you view the execution plan?
What is snapshot report?
How do indexes help, types?
How do you make a trace?
How is table type constraint applied to a table?