Answer Posted / shail

xp means extended procedure

Can the “if update (colname)” statement be used in a delete trigger?

560

---

Do you know the policy based administration feature of sql server 2008?

580

---

What is the purpose of the tempdb database?

575

---

What is a view in sql?

582

---

How to create view in stored procedure sql server?

507

---

---

What is the fillfactor concept in indexes?

536

---

What are horizontal and vertical scaling?

146

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

592

---

In which files does sql server actually store data?

475

---

What is query processing?

547

---

What is difference between count (*) and count 1?

517

---

Explain can you implement data mining in ssrs?

106

---

Explain how would you store your query in an SSRS report or a Database server?

90

---

How to convert character strings into numeric values?

582

---

What do you understand by intent locks?

577

---