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..

What is the xml datatype?

1047

---

Explain time data type in sal server 2008?

918

---

what is raid? : Sql server database administration

1033

---

Is foreign key unique?

988

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

895

---

How to loop through result set objects using mssql_fetch_array()?

1067

---

Define self join in sql server joins?

947

---

what is blocking? : Sql server database administration

1029

---

What happens when converting big values to numeric data types?

1120

---

In which tcp/ip port does sql server run? Can it be changed?

983

---

What is a primary key?

948

---

What is the partitioning method?

1016

---

What are binary string data types in ms sql server?

1275

---

ow to bring suspect mode datbase online from scratch

1800

---

Is sql server free?

911

---