p.p.s.  And, yes... I agree with the others.  If you're only seeing a 10MB transfer rate, something is seriously wrong.  We saw such a thing during one of our migrations...

p.s.  Don't forget about the possible serious problems that can occur with changes to collation in regards to TempDB.  I've not personally witnessed such a thing because I've not done...

Correct.  It doesn't always work.  If you have a trailing empty string (which is fairly common), for example, it pretty much renders it useless.

Just to use a different spoon to stir the pot a little, it's amazing how bad the use of NULL is when you work with indexes.  For example, you can...

@patrick-2,

Heh... it's so odd.  You and I actually are joined at the hip on a lot of things.

On the subject of the original app, I agree...

Whether it fixes it or not, the Quirky Update...

What about the spaces between area code, exchange, and line that were originally posted?

With the understanding that it resets when the SQL Server Service bounces and that something can be driven out of cache, I'd bet that it's code problems that need to...