Answer Posted / 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.

What are the types of database recovery models?

1057

---

What is the purpose of indexing?

1000

---

How to connect a database with sql express.?

1011

---

What do you mean by data manipulation language?

950

---

What is rolap and its advantage? : sql server analysis services, ssas

1220

---

How to throw custom exception in Stored Procedure?

994

---

how can u get last observation in an unknown dataset ?

2388

---

What is replication with database mirroring? : sql server database administration

988

---

What is cursor in ms sql server?

1092

---

What are the fixed server level roles? : sql server security

1054

---

How to assign null values to variables or columns?

915

---

How many non clustered indexes there can be on table ?

863

---

When do you think a developer should use sql server-based cursors?

978

---

can any body tell me how to know the password of current user in sql server

2027

---

How to generate create table script on an existing table in ms sql server?

1094

---