Answer / jabamit

CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC
OR ASC ORDER) BUT NON CLUSTER INDEX WORK DYNAMICALLY.

Answer / ashu_jsr

Cluster Index will be faster because data is already sorted
wrt to the index, hence you get the absolute position of
the data, where as in case of noncluster index the relative
position is given by the index

Answer / shaurabh thapa

Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.

Answer / g.ashok

Non clustered index is fast

How can you hide the sql server instances?

0 Answers  

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

What is difference between group by and having?

0 Answers  

---

---

What is the sql case statement used for?

0 Answers  

---

What the different components in replication and what is their use?

0 Answers  

---

When you should use a low fill factor?

0 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

How to create an identity column?

0 Answers  

---