How can your resolve deadlocks?
- 4 Answers
- 14426 Views
- IBM, IMS, Iron Mountain, NuWare, I also Faced
- E-Mail Answers
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
Explain the Ways to improve the performance of a sql azure database?
What is the difference between a function and a stored procedure?
What is subquery? Explain the properties of a subquery?
what are the new features in SSRS?
Do you know what are different types of replication in sql server?
Explain the dbcc pintable command when would you use it?
What is difference between views and stored procedures?
What is buffer cash and log cache in sql server?
How to make remote connection in database?
Define self join?
How to delete existing triggers using "drop trigger"?
What are the new security features added in sql server 2012? : sql server security
How to use copy and concatenate commands in SQL?
Why does sql studio use a single registered database repository? : sql server management studio
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
