Hi Sergiy,

Hey, thanks for the NOT LIKE suggestion - I wouldn't have thought of that! In our specific case I shouldn't ever get a negative integer value so that...

Hi Sergiy,

Thanks for your thoughts.

You're absolutely right about the length of integer values that would pass or fail based on a length check. I can check the length of...

Thanks to all! Select db_name() works great. My searches in BOL using 'database name' never turned it up.

Chuck

Hi Ronna,

Thanks for the indepth description of the issue.  What you say makes sense.

Note that I'm only creating a clustered index, and I'm doing this on this "scratch" table to...

Thanks for the info.  While it seemed like adding the index after was a better alternative, I wasn't sure.

A little prototyping and benchmarking is always a good solution!

Chuck

Hi Again,

I forgot to mention that the account numbers in the many primary files may be all over the range of account numbers .  In other words, input file #1...

No.  Thanks for your help.

The issue sounds like it's the same, but when I execute the statement, the process hangs like it's been blocked.  For example, currently a 2 million row update has been...

Thanks peterhe, this is the exact problem. 

I suppose because of the size of the table relative to the performance of my server, this issue became apparent - on smaller...