A side note, are you allowing tempdb to grow on your instance?

I don't believe this is a SQL Server out of memory, but I could be wrong. I would learn...

Thanks. Up late Sat (Avatar movie), up early Sun (skiing), up late last night helping my 11 yr old...

For my machine, I installed the OS. Didn't see this listed prominently on the Toshiba site when I checked their Win 7 notes.

I had meant to check what was up...

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