Answer / naren

Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.

Answer / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Answer / indraneelandhavarapu

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.

How do I find the sql server version?

0 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

Is it ok to shrink transaction log?

0 Answers  

---

What is a derived table?

0 Answers  

---

What are the different types of locks in the database?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

What is the filtered index?

0 Answers  

---

What is a primary index?

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---