Thank you all for your inputs. Appreciate it a lot.

Junior DBA could also be an entry level DBA.

Thanks, Operational dba. The person didn't have a dba background but came from application support. I'm a senior DBA and the person was hired to help me. Doesn't report to...

Yes, that works. Thanks Gaz but now I am getting "This functionality is not supported because a Report Server URL has not been specified in Central Administration" when trying to...

Hi Gail,

Yes, it is an Enterprise Edition. The main reason for the split is for IO and of course I would like to take advantage of the database availability from...

I can have a temp HD added and should I take full backup and restore the db to that backup? do u think that will resolve the issue though?

Thanks so much! This is what I'm looking for. I really appreciate your recommendations and today I learned about WITH common table expression that I didn't know before. Kidos...