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 to select some specific rows from a table in ms sql server?
What are logical/boolean operations in ms sql server?
What is tcl in sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is cdc in sql server?
What are number line correlation administrators will use while working with a subquery?
Describe how to use linked server?
how many no of arguments can be passed in procedures and functions
Does sql server 2000 clustering support load balancing?
What is scheduled job and how to create it?
What is database replication? What are the different types of replication you can set up in sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How to provide column names in insert statements in ms sql server?
Explain about system database?
What are the types of user defined functions in sql server?