Answer / moin

A deadlock occurs when there is a cyclic dependency between
two or more threads for some set of resources.

Answer / dba

P1 has lock on R1
P2 has lock on R2
P1 requests lock on R2
P2 Requests lock on R1

Where P & R are corresponding processes and resources.

Deadlock consists of two processes requesting locks on
resources thus, blocking each other.

You can avoid Deadlocks:
Access objects in the same order
Use lower isolation levels
Keep Transactions short and in one batch
Avoid user interactions in transaction
Use bound connections

Answer / 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.

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

Define full outer join in sql server joins?

0 Answers  

---

What is Lock table in SQL?

0 Answers   Wipro,

---

What is the purpose of the master database?

0 Answers  

---

Explain primary key, foreign key and unique key?

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

Why do we backup Active Directory ?

0 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

---