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.

Explain the difference between HTTP and HTTPS in database?

0 Answers   Wipro,

---

write sql program to get the detail of student in a class?

2 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

what is Archive old data?

1 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---