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

Scalability, Availability, Integration with internet, etc.)?

2878

---

How to receive returning result from a query?

1124

---

What is the process of normalising?

997

---

What is the stuff and how does it differ from the replace function?

1130

---

What are logical/boolean operations in ms sql server?

1043

---

Find columns used in stored procedure?

991

---

What are the kinds of subquery?

1008

---

What are user defined functions in ms sql server?

999

---

Write a sql query to delete duplicate records from a table called table1

1035

---

Explain aggregate functions?

1081

---

How do I find the query plan in sql server?

958

---

What is store procedure? How do they work?

1022

---

Can you explain powershell included in sql server 2008?

939

---

What is sql server database?

1011

---

Explain for xml explicit mode?

974

---