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 is full outer join in sql server joins?

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

What is spid in sql server profiler?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

List the different index configurations possible for a table?

0 Answers  

---

What is table-valued sub query?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---