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.

How to write character string constants or literals in ms sql server?

0 Answers  

---

What is a job?

3 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

What are the OS services that the SQL Server installation adds?

3 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

---

How connect excel to sql server?

0 Answers  

---

Is it possible in sql table to have more than one foreign key?

0 Answers  

---

What is amo? : sql server analysis services, ssas

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---

Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---