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.

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

Which tcl commands are available on the sql server?

0 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

What is data source in connection string?

0 Answers  

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---