How are the unique and primary key constraints different?

1073

---

What are the advantages of using cte?

1013

---

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

1101

---

How to find tables without indexes?

1088

---

What is a collation?

1092

---

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

1074

---

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

1032

---

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

1265

---

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

990

---

What does the update command do?

1111

---

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

1011

---

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

1081

---

What is the maximum row of a size?

1016

---

Does sql server 2000 clustering support load balancing?

971

---

What is unique key constraint?

1054

---