Answer Posted / naren

clustered index is created on actual data.

Non clustered index ix created on pointer of data.

If there is primary key by default clustered index is
created.
else non clustered index created.

only one clustered index is possible to create.


249 non clustered indexex can be created.

What is unique key constraint?

1068

---

What is a covered index?

949

---

What is acid properties?

1110

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

154

---

Can group functions be used in the order by clause in ms sql server?

1021

---

What is default port number for sql server 2000?

1058

---

what kind of lan types do you know? : Sql server database administration

987

---

How to loop through returning rows?

1040

---

What the class forname () does?

1074

---

how to control the amount of free space in your index pages? : Sql server database administration

1049

---

How to configure odbc dsn with different port numbers?

1090

---

How do I find the default sql server instance?

948

---

Does group by or order by come first?

965

---

How to rename an existing column with sql server management studio?

1002

---

Explain difference between cross join and full outer join?

1014

---