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 many categories of functions based their return modes?
What is sub-query in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is the usage of the sign function?
What is indexed view? How to create it?
What is difference between getdate and sysdatetime in sql server 2008?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are the different types of stored procedures?
Tell about MOM Tool(Microsoft Operator Manager)?
Explain system rowset functions?
How is foreign key related to primary key?
What is row_number () and partition by in sql server?
What is dimension table? : sql server analysis services, ssas
What is resource db in sql server?
What is global temp table?