The benefits of 64 bit are that you can access more memory and have larger caches without penalties of swapping data around in memory (with AWE/PAE)

There is no upgrade. Essentially...

Do I? Not moi. I am confident that I do a good job, and am worth hiring. There are lots of jobs for good employees.

Jays lost Halliday, likely to be below .500

I'm not sold on the Orioles. I hear this most years, but I doubt they'll compete with the other 3. The west seems...

I have removed the sample data.

As mentioned, this is entirely too much data. You can show some sample data, maybe 5-10 XML rows and that would be enough. Using real...

Jeff,

Did you get it right?

I think that it is. I can't imagine why it should help, the statistics are stored in tables, but I've seen it often noted by people as a fix. It...

tired

Don't know, but I've seen so many cases of backup / restore being slower and then fixed when stats are updated.

I think the official note is in there

"we do not support an in-place upgrade from any 32bit SQL Server to any 64bit SQL Server."

I'm sure that's noted in BOL...

They are not slower. Not for standard inserts. It is likely that your test setup is not properly simulating things. Perhaps statistics are not up to date, the I/O subsystem...

Be sure you walk through all failure scenarios and then make sure you have enough flags in your order details to handle the possible places where you need to keep...

Robbert,

Thanks, didn't realize that. In essence, I think that means that all your encryption security is gone if someone can get Admin access to the box. A hole I didn't...

If you're using RDP, network isn't an issue.

Stats should move, but as Jeff mentioned, they often don't seem to in a backup/restore.

Setting password to not expire is a bad idea. They ought to be changed periodically.

I've done this two ways. Note that this was relatively low volume, but it worked in each case.

1. We process the order and load into the DB. Meaning everything is...