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.

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

In which files does sql server actually store data?

0 Answers  

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers  

---

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

What options are available to audit login activity? : sql server security

0 Answers  

---

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

---

Who developed sql server?

0 Answers  

---