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.

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What are views used for?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What are the types of lock supported by ?

0 Answers   HCL,

---

Mention the different types of replication in sql server.

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

What is the purpose of self join?

0 Answers  

---

What is transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

What is cursor in ms sql server?

0 Answers  

---