Interested to Buy Any Domain ? << Click Here >> for more details...
What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10851 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raghu
Consider there are transcations going on 1 row, some one is
trying to update a column in that row while others are
trying to retrive data of same row,while update locks the
row for some period of time others cannot select it, hence
deadlock occurs.
To kill the process is solution. In sql server 2005 use sql
profiler to view the process, in that see the column named
transactions if its value is more than 1 right click and
kill the process.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are different types of replication in sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration
Explain how to use linked server?
Explain linked server in sql?
How you would rewrite the sql query to return the customerid sorted numerically?
What are the basic features of a trigger in ms sql server?
What are the differences between stored procedure and the dynamic sql?
What should be the fill factor for indexes created on tables? : sql server database administration
How do I create an extended event in sql server?
Write a SQL queries on Self Join and Inner Join.
What is the new security features added in sql server 2016? : sql server security
What are out-of-range errors with date and time literals?
How many types of subqueries are there in sql server?
what's the maximum size of a row? : Sql server database administration
Explain steps of normalization?
