Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15480 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 ssrs?
What is explicit cursors?
How to write a query with a full outer join in ms sql server?
What is factless fact table? : sql server analysis services, ssas
What is side by side migration in sql server?
How can a user-defined datatype be created?
What is the purpose of data source?
How do I completely remove sql server instance?
What are the difference between primary keys and foreign keys?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are advantages of ssrs or why we should use ssrs?
What is the usage of the sign function?
What is use of except clause?
What are the steps you should follow to start sql server in single-user mode?
Why is normalisation important?
