What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

How can you list all the table constraints in a database?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

How to write character string constants or literals in ms sql server?

0 Answers  

---

What are primary keys and foreign keys?

4 Answers  

---

---

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

---

Explain features and concepts of analysis services?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

What happens if null values are involved in string operations?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What are system databases in ms sql server?

0 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---