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
Can you tell me about the concept of ER diagrams?
Do you know the cursor optimization tips?
how can u get last observation in an unknown dataset ?
How to generate create table script on an existing table in ms sql server?
What is the use of toad or sqldbx.?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
How many triggers you can have on a table?
What are advantages of ssrs or why we should use ssrs?
What are the acid properties?
What are the different types of sub-queries?
What is the difference between count () and rowcount ()?
What is inner join in sql server joins?
Explain important index characteristics?
What is the use of for clause?
What are ddl (data definition language) statements for tables in ms sql server?