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?

Some people stink, Gail. I've had more than a few complaints as well. That's part of the reason why I include the disclaimer right away.

I suspect that your reorg is good enough, but you never know. I'd actually be looking to do this after an upgrade, since changes to the schema might move things...