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

What is the importance of concurrency control?

0 Answers  

---

What is acid mean in sql server?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What is difference between inner join and join?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

What are the requirements on sql server network connections?

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

Explain a checkpoint?

0 Answers  

---

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---