Answer Posted / shakila

Ya it's right

What does this statement do @@rowcount?

926

---

What is recompile sql server?

991

---

Tell me something about security and sql azure?

114

---

What is report subscription?

117

---

Explain about service Broker functions?

985

---

How to trouble shoot if unable to connect SQL Server

1926

---

What is 3nf normalization?

928

---

What is the fastest way to permanently delete a 1 million row table named customers?

1155

---

Explain about thread and memory management process of SQL?

925

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1006

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1100

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1328

---

What does the not null constraint do?

1002

---

What is order of B+tree?

1063

---

What is thr feature of change data capture?

920

---