Answer / 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

List down some advantages of sql stored procedure?

0 Answers  

---

What is join and name different type of joins?

0 Answers  

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

what is database replicaion? : Sql server database administration

0 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

How to use linked server?

0 Answers  

---

What is local temp table?

0 Answers  

---

How do I open port 1433?

0 Answers  

---

Do you know what are the properties of the relational tables?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

Do you know what is fill factor and pad index?

0 Answers  

---