Answer Posted / rajan

full form is xp is eXperience and it is 100% right

Do you know exporting and importing utility?

1107

---

What is sql server 2000 work load governor?

1160

---

What happens if null values are involved in bitwise operations?

1081

---

How do I create a partition table in sql server?

1185

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1195

---

What is update_statistics command?

1121

---

How can I check that whether automatic statistic update is enabled or not?

1097

---

explain extended properties

1038

---

Does partitioning improve performance?

1023

---

What is a schema in ms sql server 2005?

1027

---

What is the significance of master, tempdb and model databases?

1132

---

What happens to a statement batch if there is a compilation error?

1012

---

What is the difference between deallocate cursor and close cursor?

1335

---

how to invoke a trigger on demand? : Sql server database administration

1155

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1222

---