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...

http://www.pmi.org/Pages/default.aspx

I like a lot of what Cuban says, and I think he does some things right for this country. But like all of us, he's fallible as well and there...

Are you sure that all subscribers are getting the data? Might be one out there that's missing things.

Also, what's the recovery model? Log backups running on a full mode db?