Process monitoring is running now. In a day or two I will analyze the results.

In the previous version of the website, I was writing all of my queries in ColdFusion,...

I am well aware of the gospel that says not to put them on the same box. Unfortunately I did not have a choice at the time.

I work in an...

I think a 'best practice' would be dictated by how often this situation arises.

If your users are deleting rows that you are constantly having to go back and restore, then...