Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15648 Views
- IBM, IMS, Iron Mountain, NuWare, I also Faced
- E-Mail Answers
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
What is isnull() operator?
What are the different index configurations a table can have?
What are the types of lock supported by ?
What is table constraint?
What is surrogate key? : sql server analysis services, ssas
What are the advantages of policy management?
What does sql server mean?
What is right outer join in sql server joins?
In what version of sql server were synonyms released?
Do you know what is lock escalation?
Do you know what is xpath?
Does partitioning improve performance?
What are different types of constraints?
How do I start and stop sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
