I am sitting on a non-windows machine at the moment so can't offer a solution. Have you looked into using extended events to try and capture what you...

I really like what UDP shared. Definitely performance focused. I get the sense from the original questions that indexes and tables will be going on different drives....

/* double post - removing */

As someone mentioned above go take a look at your SSMS settings and batch terminators. I don't know for sure, but that might be the cause of the...

Agreed w/all above. Tis possible. However, you may want to consider any issues you may encounter because of differences between the two editions. Something as simple...