Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15340 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
Explain various data region available in ssrs with their use?
How can we delete Duplicate row in table?
What stored by the master? : sql server database administration
How to filter records of table in SQL SERVER?
Can you name some of the dml commands in sql?
What command would you use to add a column to a table in sql server?
How to make conditional sum in ssrs?
Differentiate between a local and a global temporary table?
What is index in an assignment?
What is a matrix in ssrs?
Are resultset updatable?
What are triggers? How do you invoke a trigger on demand?
What is subquery in sql?
what is datawarehouse?
What are the different normalization forms?
