When installing SQL server to the same drive as your OS, be very diligent in making sure that EVERY file that SQL server can cause to grow is moved off...
When installing SQL server to the same drive as your OS, be very diligent in making sure that EVERY file that SQL server can cause to grow is moved off...
In terms of productivity, as a manager, the measure of my productivity is in how effective I am in facilitating my direct reports ability and desire to be productive.
I have, in the past, created views on the local server that contained the required remote data. Although you don't get quite the performance gain from copying the data down...