Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15493 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
Can you import Microsoft Excel data to SSRS?
What is the sql case statement used for? Explain with an example?
Does sql server use t sql?
How to list all user defined functions in the current database?
Can you explain what is indexed view? How to create it?
What is msdb database? : SQL Server Architecture
What is use of @@ spid in sql server?
What do you know about normalization and de- normalization?
Explain few of the new features of sql server 2008 management studio
What are the steps to follow to configure SQL*Net?
What are different types of statement?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How sql server enhances scalability of the database system?
What is de-normalization in sql database administration? Give examples?
What is a file group?
