For cases where we have dynamic sql, there is an additional parameter labelled @debug bit = 0  in the arguments.

At the end of the script, there is a check for...

Or partitioning. It's not unusual for us to have many 10's of millions if not 100's of millions of rows, but not need the power or performance that an...

I agree 100%. There are several instances where we need features like partitioning, but don't need the raw CPU horsepower of more than 2 cpus (multiple cores though). ...