What is deadlock and how to avoid the deadlocks.
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 the difference between data mart and data warehouse? : sql server analysis services, ssas
What are the instances when triggers are appropriate?
How to attach adventureworkslt physical files to the server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Explain optimistic and pessimistic concurrency?
What is the purpose of data source?
What are the properties of primary key?
What are the diifferences between the ms sql server vs mysql?
What is the difference between a "where" clause and a "having" clause?
What is resource governor?
What do you mean by an execution plan? How would you view it?
What are constraints?
Explain how to send email from sql database?
What do you understand by SQL*Net?
What is the difference between char and varchar2 datatype in sql?