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...

I thought the Linux one was old, though perhaps it may be recycled in the future. 😉

I'm not sure I fault her for wanting her share of the marriage. Both of them are a little silly, however, as are many of the demands athletes make. They're...

NULLs HAVE been deprecated, haven't you heard. SQL 11 will have no NULLs, Start rewriting now, defaults required, blah, blah, april fools, new code, more work, etc. etc.

Thanks for this thread, and the question. Went over well today, I think

Paul White NZ (4/1/2010)

I looked for that...