Answer Posted / palpantian

A clustered index is a special type of index that reorders
the way records in the table are physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.

How many replicas are maintained for each sql azure db?

122

---

What is partitioned view?

852

---

Explain transaction server isolation?

979

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

Can an automatic recovery be initiated by a user?

941

---

Write the syntax for stuff function in an sql server?

976

---

how we use window authentication connection with sql server.?

1083

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

849

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

997

---

What are a scheduled jobs or what is a scheduled tasks?

847

---

What are dml triggers and types of dml triggers?

921

---

What is difference between commit and rollback when used in transactions?

904

---

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

1015

---

Comment,Datatypes are unlimited

2015

---

How to Insert multiple rows with a single insert statement?

999

---