What's the "app" on the app server?

In addition to what's noted above, I'd be sure you set the max memory that SQL will use so that it doesn't starve the...

This help?

http://sev17.com/2009/01/dynamically-register-sql-instances-in-sql-server-management-studio-2008/

Isn't it happy hour for you, Gianluca?

Relax, ultimately you want to be professional, but it's a job. Give you opinion, document, go with the crowd if they want to drive...

I completely agree with Gail. DO NOT put database files on the network. The network is for sharing resources, but SQL does that for you. It allows multiple people to...

I have queried the VC about recording. Andy did this at the Jacksonville code camp and it was well received.

bloopers

Getting ready for Mon. That and a baseball game with Ray K.

I'd implement the FK, document my issues, and pull it back out when he complained about performance.

You can build a simple SSIS package using the import/export wizard in SSMS.

I've been to the Summit most years, and there are two big values from going:

1. Getting great educational presentations that teach you things and get you to think.

2. Networking with...

I'd agree with Craig. Too many differentials increases your effort, and your risk. If that full cannot be restored for some reason, then you could lose everything.

At the very least,...

Isn't that WayneS's avatar?

The logs are pretty good about informing you what is wrong. Address the issue, and post back if you don't understand.

Here is the hardware requirement for 2005: http://msdn.microsoft.com/en-US/library/ms143506%28v=SQL.90%29.aspx

I'd send them a business card. $100/hr, be happy to work over RDP and install SQL for you.

Have you checked the default trace for what might have been executing and correlating that with the code that used a lot of resources?

I think so. I'll try to go over there and comment on a few things. Feeling slightly over committed right now.