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.

Can we write a distributed query and get some data which is located on other server and oracle database?

1225

---

Which are ddl commands?

1038

---

How to copy data from one table to another table?

993

---

What are the types of processing and explain each? : sql server analysis services, ssas

1146

---

Explain about Views?

1063

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1038

---

Can we take the full database backup in log shipping?

942

---

What do you mean by data manipulation language?

1013

---

How can we remove orphan records from a table?

980

---

What are different types of collation sensitivity?

987

---

Difference between uniqe index and uniqe constraint?

976

---

What is difference between stored procedure and user defined function?

1097

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1036

---

What is a rollup clause?

965

---

What are the purpose of Normalisation?

1048

---