homebrew01 (5/10/2013)
Bigger picture: Propose to management that a reporting database be created and updated (preferably on a different server) and let users query against that database instead. Still not ideal to let users write queries, but it would take the load of the existing database.
Did that already.
At this point, we have no additional hardware, space and resource for that.
Good advice though.