sqlfriends (2/5/2013)

---

We have a database server that has databases for research department.

It is used mainly for them to read data using select queries, or combine some data together to write to new table.

Sometimes they wrote complicated queries to join across databases on the server and the query runs minutes.

I see there is Optimize for AD HOC workloads database property, its default is false, to make it true, will that help? What does it mean?

thanks