http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

Rarely. Usually only for patches. The SQL ServerCentral.com database has been rebooted once this year for a Windows patch application. Other than that, it's been up since September when we...

Ahhhhhhhhhhh :0

Managers and Access. Keep them away!!!!!

A select count(*) from x where date >= date1 and date <= date2 should work, are you just wanting the number of rows?

http://www.sqlservercentral.com/scripts/contributions/26.asp

This usually works for me.

A proc will not directly take a stream as an import mechanism. It will take text and you'd need to somehow get your file loaded into memory and then pass...

We've got some stuff in the Sept magazine on various scale and HA issues coming. Might answer some questions.

As far as scale goes, I can point to two places...

Nice to know I have some company

It's funny how things that you do regularly come back to bite you when you twist them...

Wow, a rare complement from Mr. Mechanic.

Unfortunately, you are correct. I have more to tell .

Feel free to submit your own. Or am I the only one that's made this...

I've mostly sent small files over a short WAN (3 hops), so I haven't seen any issues with performance. The largest files were 10's of MB, so not huge...

It isn't clear from the posting what you have set up and where the rollback is. Is the rollback in the stored procedure? Is this something you think should be...

Not offhand. I haven't seen this stuff documented, most likely companies have licensed it or just reverse engineered it.

replication is a great choice if you can get it implemented at an ISP. Some won't allow it.

I'm a little confused. You say the main way of updating is a...

Backup and restore does not change any object owners. There must be something else at work.