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 is blocking and how would you troubleshoot it? : sql server database administration

1055

---

What do you mean by data manipulation language?

1025

---

What is catalog views?

1075

---

What is an example of a primary key?

996

---

What is a transact-sql statement batch in ms sql server?

1031

---

What is the syntax for encrypting a column in SQL Server?

1128

---

Explain filtered indexes benefits?

1010

---

Explain transaction server distributed transaction?

989

---

Define tool Manage Statistics in SQL Server 2000 query ?

1100

---

Explain the commands in sql server?

1045

---

How does Report Builder support Analysis Services cubes?

156

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1127

---

How to change a login name in ms sql server?

1096

---

What stored by the master? : sql server database administration

1116

---

Delete duplicate rows without using rowid.

1541

---