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

I've edited your code. You highlight it and then click the " on the left to format it.

What you should do is not "execute" the code, but do the print...

Robert,

Is that true? In that case, security is being bypassed for single user mode. That's a big hole. If you don't have rights, you shouldn't be able to connect in...

It is easy to paste in, and honestly I'm not sure that I'd do it for this reason. However I do think that this is an interesting idea, and it...

I think the answer is highly dependent on options, which makes it a poor question. It could appear to be one way or the other in many tests, until you...

It's an auditing message. You must have a setting enabled to log failed logins and the instance is logging them. It means that someone attempted to log on with an...