How are the unique and primary key constraints different?

1083

---

What are the advantages of using cte?

1037

---

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

1126

---

How to find tables without indexes?

1100

---

What is a collation?

1107

---

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

1089

---

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

1043

---

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

1280

---

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

1012

---

What does the update command do?

1124

---

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

1022

---

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

1095

---

What is the maximum row of a size?

1030

---

Does sql server 2000 clustering support load balancing?

987

---

What is unique key constraint?

1070

---