How are the unique and primary key constraints different?

1129

---

What are the advantages of using cte?

1079

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167

---

How to find tables without indexes?

1160

---

What is a collation?

1136

---

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

1122

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1077

---

What is a raid and what are different types of raid configurations?

1327

---

Will sql server 2005 allow you to reduce the size of a column?

1063

---

What does the update command do?

1175

---

Can you type more than one query in the query editor screen at the same time?

1073

---

How do I find information about the install locations for the various instances running on a computer?

1130

---

What is the maximum row of a size?

1072

---

Does sql server 2000 clustering support load balancing?

1030

---

What is unique key constraint?

1119

---