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.

Correct. This is hyperthreading. The SQL Server Central.com boxes are 2 way, but show up as 4. There's been some debate as to whether or not hyperthreading is bad for...

Not that I know of. I know when I've need SQL to pick up a new IP, I usually have to restart.

I saw this at a deonstration byu DB Assciates (now Imceda) years ago. It's one of the reasons all the backup products include encryption capabilities.

I thought about including that one, but then everyone would pick it and then all you great DBAs would be looking for new jobs when your manager gave the junior...

From the lead storage engine developer: Table variables are materialized in tempdb.

I thought they were in memory as well until a couple weeks ago.

Wasn't us and there has been some question. In speaking with the storage engine devlopers at TechEd they said there isn't a big difference between them. Some restrictions on table...

I definiteley agree with access to resources. At least the tools that come with the product if not the Internet.