Answer Posted / darshan

Hi
1)
First find out which process block the other process from
activity monitor or sp_who2. Then kill that process.
2)
If update locks are more then it will make deadlock. So
reduce that.

What is the use of stored procedure?

948

---

Do you know exporting and importing utility?

1051

---

What do you understand by coalesce in sql server?

1083

---

How to get the query of a table in sql server?

908

---

What are system databases into sql server (2005/2008) : sql server database administration

1022

---

Why is sql server log file full?

1049

---

What is set nocount on and what is set nocount off?

939

---

What is difference between temp table and cte?

1040

---

Explain the concepts and capabilities of sql server?

986

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1067

---

What command do we use to rename a database?

1091

---

Which is better statement or preparedstatement?

937

---

How to create user messages with print statements in ms sql server?

999

---

What is the difference between set and select?

1106

---

Can binary strings be used in arithmetical operations?

945

---