Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15464 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 are two difference between sql azure and azure tables?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What’s the use of custom fields in report?
Give an example of SQL injection attack ?
How to optimize stored procedures in sql server?
Do you know how to implement service broker?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is data compression?
Define Business Edition in SQL Azure?
How do you manipulate data?
How to restore performance issues and how to check?
What is the concept of optimization?
What are the different types of join?
What is the difference between Clustered and Non-Clustered Index?
How to execute a sql statement using odbc_exec()?
