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 side by side migration in sql server?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

Can we insert data into a view?

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

What is the command used to get the version of sql server?

1 Answers  

---

What is MSDE?

2 Answers  

---

What is resource db in sql server?

0 Answers  

---

What are partitioned views?

0 Answers  

---