Answer Posted / james bond

All are mad with cluster index.
they don't know wht the exact difference.
(All these are book worm.they just a ctrl+C and Ctrl+v and
nothing else)

Clustered index proper way to findd desired data like
rowndex(physical form of data) and non clustered is
mapping of these clustered index in differnt form.

(Don't try to keep as written on your mind. think it and
then use it??)

Do you know how to implement service broker?

886

---

What are the essential components of sql server service broker?

965

---

What is triggers in ms sql server?

1050

---

Is it possible to call a stored procedure within a stored procedure?

914

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1988

---

What is inline table-value user-defined function?

1011

---

Does a server store data?

864

---

What is tempdb in sql server?

920

---

Do you think BCNF is better than 2NF & 3NF? Why?

1226

---

What is the function of inner join?

1004

---

What is difference between rollback immediate and with no_wait during alter database?

1016

---

What is resource db in sql server?

963

---

What are truncate options available in sql server? : sql server database administration

966

---

Explain what are various ways to enhance the ssrs report?

990

---

what is a self join? : Sql server database administration

962

---