From running both, it's going to come down to the size of your database.  If it all fits in memory, then a slight increase with the faster cores, but if...

It really depends on your use case.  For us, the extra memory and faster storage, helped us level out some of the performance issues we were having on the General...

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). ...