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 an indexed view?

960

---

Explain the microsoft sql server delete command?

1025

---

What is normalization and its types?

1040

---

What is a domain constraint give an example?

1049

---

Explain different types of index?

1064

---

whats new about truncate in sql server 2008?

2502

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1903

---

How to change the system date and time from SQL Plus Terminal ?

1223

---

List the different index configurations possible for a table?

934

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1256

---

Explain index in sql server?

1021

---

What is a trigger and its types?

994

---

What is sql sandbox in sql server?

1230

---

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

1080

---

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

161

---