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 to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

Explain trigger and trigger types?

0 Answers  

---

Explain query editor regions

0 Answers  

---

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

Why normalization is used?

0 Answers  

---

What is split brain scenario in DB mirroring?

1 Answers  

---

Explain timestamp datatype?

0 Answers  

---

Where is localdb stored?

0 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---