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?

code pages?

First I never back up to the network. Too unreliable and it will fail when you least expect it. Like the day that your database goes down. Backup locally, copy...

I did something similar years ago, but I used replication. Basically when something changed in source, I replicated the relevant table to the destination to staging tables. 3 (or however...

Not sure, but I'd move the DB to another server or drive and ensure it's not corrupt. There could be disk issues on the server and a complete copy to...

Thanks for the update, you had us stumped. I've only been able to change the OS time and have SQL lag by about 5-10sec at the max before it catches...

Thanks for the update and be aware that there are sometimes strange caching things that break for unknown reasons. Relinking would have been my suggestion if I were a little...