I would join the chorus and agree with most of the comments proritizing family needs over company needs. I'll add the comment that if your department has been constructed...
I totally agree, I have been using Spotlight to evaluate the server and gradually cleaned up most of the warning messages. Soft Paging and CPU cycles > 80% , and...
I really like this analyzer as well . One of the benefits from it is that I have an "official" MS declaration of best practices that I can now incorporate...
I would suggest that you check your client access configuration( or is it in ODBC??) under performance, turn off row blocking and maximize your blocking size. as far as my problem goes...
I agree regarding auto close, but disagree regarding auto shrink. Reason: I have many databases to deal with some of which grow their logs very fast eating up valuable disk...