Glad you liked it, Dave. Took awhile to try and write it up and get something that looked real. Phil Factor helped flesh out details in a few places.

Ever seen a joke bomb? It happens all the time to comics, so there can be a wrong attempt.

Actually it's more that our engine allows only "1 right answer" or...

I don't think you can just measure yourself by someone else at work, and their efforts to get ahead. That's a game that's not worth playing most of the time....

do-do-do-doo-do

Retakes are important, and there should be some time. I think that Novell allowed one retake for free and then you had to wait at least a week or a...

I think the statement that table variables don't participate in transactions is clearer. It implies that they can be exempt from a rollback, which is handy. I worry about marking...

Mike,

One thing I'd also suggest, especially in a big city like NYC, is that you schedule an early BOF session or two, and just have someone there to moderate or...

Run the upgrade advisor from 2008 to check for any code issues.

The above posts have covered the issues fairly well.

That's one reason I include the disclaimer. Some people don't get it's a joke, and they might be tempted to use the advice. I was worried that they might try...

There's some overhead to replication, but it's likely a more stable overhead than having people run queries. It reads through the transactions and moves them across.

What I'd recommend is replication. Or even using SSIS and building a data warehouse of sorts.

Log shipping works, but when it restores the logs, it kicks people out of...

Is your server responding on UDP 1434 as well? That's typically what the Browser is on by default. It translates the port.

It's fair use.

I pinged Eric, and not sure what he'll do. I did let him know that some people see the facts as incorrect.

I believe Gift Peddie is correct. The mode doesn't affect how IO processes, it affects how code/keywords are interpreted.

Doh!, you're right Paul. I'd forgotten that.

Have you tried just a straight rebuild on one of these tables to see what is does?