How can your resolve deadlocks?
Answer Posted / xavier rajan, photon infotech
A deadlock occurs when two or more
processes try to access a resource that another process has
a lock on. Microsoft SQL Server automatically
detects these deadlocks, terminates one of the processes,
and rolls back any changes made by that process.
The process chosen for termination will be the one with the
least amount of active time on the server. In
most cases, you can simply reissue the statements that were
rolled back and should have no problems.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Tell me the phases a transaction has to undergo?
What is the Control Flow in SSIS
Explain the difference between function and stored procedure?
What are the purposes and advantages stored procedure?
When you should use a low fill factor?
What do you mean by cardinality?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How to replace given values with null using nullif()?
How extra digits are handled with numeric data type literals?
What is relationship? What number of sorts of relationship are there?
What do I need to start working with sql studio? : sql server management studio
Explain candidate key, alternate key, and composite key?
What is data compression? : sql server database administration
What is a non equi join?
What is sub-query in sql server? Explain its properties.