How are the unique and primary key constraints different?

1129

---

What are the advantages of using cte?

1081

---

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

1169

---

How to find tables without indexes?

1164

---

What is a collation?

1141

---

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

1130

---

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

1084

---

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

1332

---

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

1068

---

What does the update command do?

1177

---

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

1075

---

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?

1031

---

What is unique key constraint?

1121

---