Answer Posted / arunyadav007

Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.

Thanks,

Arun

Can we perform backup restore operation on tempdb?

953

---

What is query optimizer in sql server?

956

---

What is mean by dml?

945

---

How do I schedule a sql server profiler trace?

912

---

Do you know spatial data types - geometry and geography in sql server 2008?

968

---

What is apply operator in sql?

956

---

How to find the source of a table in sql server?

920

---

What is user defined stored procedures?

876

---

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?

1325

---

What is awe?

947

---

How do I find query history in sql server?

874

---

Name the different type of indexes in sql?

906

---

What is the command dbcc checkdb used for?

962

---

What is a trace frag?

1035

---

How do I install only the client tools of sql server 2000?

991

---