Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Answer / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

What are the different acid properties?

0 Answers  

---

What are the triggers in sql?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

What is a performance monitor?

0 Answers  

---