yes, we already do that on both the old and new system. Thats standard across our enterprise. We're discussing changing the affinity to give the OS its...

we updated the stats over the weekend, but didnt run DBCC FREEPROCCACHE. That has since been fixed. Good idea about dedicating a core to the OS, that...

I checked and we have it set correctly with local rights. This is a dedicated SS box and we have max server mem to 120 gig of 128. ...

1. If you aren't already, you should think about implementing x64 on this hardware to take max advantage (cache above 4GB, etc.). It looks like you may be running x64...

In terms of CPU drop, is that between the two boxes (old and new) or after you set max memory?

Not sure about L3, have to ask someone else about that,...

interesting. I'm sure I checked it as well as my boss and two other DBAs. How could we all have missed it. Its now set and I...

...or find any instances of double qoutes in your text file and replace with single qoutes before executing the import.

Does anyone ever get really 'Clean' data?

'nix