Answer Posted / gudny34

Hi..U can get info here.It can be helpful.
<a href=http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file>http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file</a>

What is the openxml statement in sql server?

1125

---

What are subqueries in sql server? Explain its properties.

1072

---

What are the differences between web role and worker role?

124

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1054

---

How to scale out a federation by Sql statement?

118

---

Explain stored procedure?

1110

---

What is tempdb in sql server?

1029

---

What is auditing in sql server?

969

---

What is the name of the Database which IBM mainframe uses?

1033

---

What are drilldown reports?

160

---

What kind of problems occurs if we do not implement proper locking strategy?

1467

---

Explain a differential backup?

1064

---

What are the differences between local and global temporary tables?

1134

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

---

What is difference between foreign key and unique key?

1050

---