Answer Posted / hari

Deadlocks occur when two or more processes place a lock on
the same resources and each process waits for the others to
release the lock.

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1034

---

Do you know sql server 2008 introduces automatic auditing?

915

---

What is a primary index?

885

---

Can an automatic recovery be initiated by a user?

943

---

What is bcp? When does it used?

923

---

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

973

---

explain extended properties

929

---

What is the sql case statement used for? Explain with an example?

941

---

Explain the properties of subqueries in sql server?

1019

---

Explain alternate key, candidate key and composite key in sql server?

862

---

What is the boxing and unboxing concept in .net?

868

---

Explain the architecture of ms sql reporting service?

873

---

What is mean by dml?

946

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1090

---

What method is used by the Command classes to execute SQL statements that return single values?

1007

---