Answer Posted / bru medishetty

What is the context here with SQL Server?

Cannot help if you cannot post a meaningful description.

Thanks,
Bru Medishetty

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1263

---

How to set database to be single_user in ms sql server?

1078

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

1037

---

Can you pass expressions to function parameters?

1149

---

What do you mean by acid?

1048

---

What is recompile sql server?

1079

---

What is rank function?

1082

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

---

What is a partitioned view?

1049

---

Difference between report and query parameter.

1138

---

Explain syntax for viewing trigger?

964

---

What is the purpose of sql profiler in sql server?

1063

---

Explain error handling in ssis?

1066

---

What is data source view or dsv? : sql server analysis services, ssas

1052

---

How to change the ownership of a schema in ms sql server?

1251

---