What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 10107 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 clustered and non-clustered index?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How to define and use table alias names in ms sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Explain the microsoft sql server delete command? : SQL Server Architecture
How to change the ownership of a schema in ms sql server?
How to view the error log for any specific instance? : sql server database administration
Explain can SSRS reports Cache results?
Tell me the difference between clustered and non-clustered index?
What is an inner join?
what is raid? : Sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
Explain the rules for designing files and file groups in sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
what are user defined datatypes? : Sql server database administration
