The response from YouTube is well done and it outlines the issues. They need to protect themselves because of the laws. It also seems to hint to the McCain campaign...

This does sound strange and I don't think this happens often. It's likely an anomaly as mentioned above. If it happens again, I'd recommend calling MS, running PSdiag, and posting...

If you're willing to do Broker, I'd do that. It gives you some flexibility to move the archive to another server/system easily later if need be. Harder to do that...

First of all, is the hardware the same? Or how is it different? Check drivers, especially disk drivers, as issues there can really affect performance.

Next, you have to examine plans...

could be a lot of things, hardware, load on either server, disks, etc. check the plans, be sure they're running efficiently, look at load on the servers, check the speed...

Is it always the year after?

Convert the year to a number if it's not, add one, convert to char, take the right 2 characters.

Use

CAST() and RIGHT()

And please watch the forums. Moved to the DTS forum.

Well SQL 2005 supports 6.5 versions, which are 10 years old. however I'm not sure of the upgrade / restore policy.

Honestly what I've done in the past is archive the...

If you are getting connected to SQL Server, then you should see databases. If you uninstalled and reinstalled, did you re-attach databases? If not, they won't be there.

If this is...

SQL Server will manage memory, but it's slow to do so and it doesn't like to give it up. If you must run Cold fusion or something else that needs...

Good explanation from Barry and others.

The idea behind disable/enable, is to grant access to the server or not. It's like having keys to the front door. You have them or...

Likely you have a corrupt client tools installation.

Please don't cross post. I think this was posted elsewhere.

Yikes! Get well soon, Barry, and I'll bring some tin foil to PASS for Jeff 🙂

Ignoring politics, though you're welcome to send me an email on that, if we ignore copyright or review it more, then do we do the same for other types of...

Good article and with versions coming every 3 years, they're close enough that I'm not sure you gain anything from having forklift upgrades of all servers. Kilmanjaro, the next version...