Answer Posted / upma

when u create primary key in a table than cluster index are automatically created...becoz there can b only one primary key on a table,so cluster index is one in a table.cluster index reorder the way records in a table are physically stored...
Non cluster index,when u create unique automatically generated... 249 non cluster index in a table,because we can apply more than one unique key in a table..
logically order, does not match with physical order..

How to create an identity column?

1299

---

What is equi join with example?

1224

---

Distinguish between nested subquery and correlated subquery?

1111

---

What is extended stored procedures?

1022

---

Why should one not prefix user stored procedures with ‘sp_’?

1095

---

What is history table in sql server?

1028

---

What is raiseerror? What is raiseerror?

1191

---

How to rebuild all indexes on a single table?

1106

---

What is the library index called?

1107

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1129

---

What is the partitioning method?

1062

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1211

---

Name some of the open source software that you can use in alternative to SSR?

169

---

What is surrogate key? : sql server analysis services, ssas

1158

---

What is the difference between a stored procedure and a user defined function?

1060

---