Answer Posted / ankit murela

cluster index:- (1)only one cluster index can be created.
(2)sort the data physically.
(3)Applied on columns which are not modifier frequencely.
(4)the leaf nodes of a cluster index contain the data pages

non-cluster index:- (1)there can 249 non cluster index per table.
(2)does not sort the data physically.
(3)Applied on columns which are modifier frequencely.
(4)The leaf nodes of a non cluster index does not contain the data pages

What does the update command do?

1169

---

What is trigger explain with program?

1014

---

How many instances per computer are there in sql server 2000?

1117

---

How do I setup a sql server database?

1126

---

Explain “row_number()” in sql server with an example?

1051

---

What is the recommended total size of your memory optimized tables?

1004

---

Explain error and transaction handling in sql server?

1057

---

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

993

---

What are the advantages of using cte?

1072

---

Can I save my report as html, excel or word? : sql server management studio

1006

---

List out some of the requirements to set up a sql server failover cluster?

1072

---

Explain the benefits of user-defined functions?

1120

---

What is an indexing technique?

977

---

What is the use of =,==,=== operators?

1057

---

Why I am getting this error when renaming a database in ms sql server?

1100

---