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.

What are the disadvantages of merge replication?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

How we can compare two database data?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

Tell me what is a linked server?

0 Answers  

---

What is sql injection and why is it a problem? : sql server security

0 Answers  

---

What is extended stored procedures?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

Explain mixed authentication mode of sql server?

0 Answers  

---