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.

Can we drop user if user mapped to any logins

1 Answers  

---

Can a rule be bound to any column of any data type?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

What are the types of containers in ssis?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

What is use of except clause?

0 Answers  

---

What are the five characteristics of good data?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

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

0 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

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  

---