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

What is a rownum?

946

---

What is normalization? Explain its different types?

1071

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2055

---

Give an example of SQL injection attack ?

986

---

How do we know if any query is retrieving a large amount of data or very little data?

954

---

Explain indexed views and partitioned view with their syntax.

1120

---

What is an execution plan? How would you view the execution plan?

1051

---

how to take backup bcp out for a column in table in sql server?

2081

---

How can change procedure in sql server?

1032

---

Why use cursor in sql server?

1059

---

What do I need to start working with sql studio? : sql server management studio

1089

---

What is query cost in sql server?

973

---

Difference between LEN() and DATALENGTH() in sql server ?

1087

---

How to verify a user name with sqlcmd tool?

1054

---

Can we take the full database backup in log shipping?

930

---