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.

Explain insert into select statement?

896

---

What is acid db?

838

---

Can you explain what is indexed view? How to create it?

850

---

How to create a new schema in a database?

1069

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1048

---

Explain filestream storage of sql server 2008?

947

---

Tell me what are the essential components of sql server service broker?

884

---

Write a sql query to delete duplicate records from a table called table1

970

---

What is partition, how will you implement it? : sql server analysis services, ssas

991

---

What are the different acid properties?

1012

---

How does stuff differ from the replace function?

956

---

Does hive support indexing?

905

---

Is the order of columns in the set clause important in ms sql server?

925

---

What is measure group, measure? : sql server analysis services, ssas

959

---

What is the difference between value type and reference type?

864

---