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.

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

What are the dmvs? : sql server database administration

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

Explain left outer join and right outer join?

0 Answers  

---

Explain transaction server implicit?

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

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

0 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---