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.

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

What is the process of normalization?

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

What is normalization?

9 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

How many types of triggers in sql server?

0 Answers  

---

Explain in brief about Microsoft SQL server?

0 Answers  

---

How do you trace the traffic hitting a sql server?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---