Well, yes, but again, wouldn't that be served best by being able to physically separate the locations? With a RAID array, everything goes down one pipe, it's up to the...

Thank you both, that confirms my thoughts on the paid version of SQL Server - little point in having all that RAM and processors if they're not getting used.

But I'm...

Save yourself some time - just hire Gail.

So, let me see if I have this straight:

Dev DB

Simple Recovery mode

For each reload cycle:

- Empty and refill from live

- Checkpoint (to keep from bloating log)

- Backups not necessary, except...

http://www.mrexcel.com/forum/index.php

Looks useful, but I get an error on the reporting database name. Is it because I am using Express version, or can I do something to make it work?

Blanket prohibitions are generally a bad idea in any field. All processors have Jump instructions, which are low-level GOTOs, and high-level languages compile or interpret down to that, so your...