A third option I failed to mention:

3. Perform the update, if zero rows are affected, perform the insert.

Relying on error handling for a common condition makes me a bit uneasy,...

You might want to check out this page to verify that you are actually using Unicode http://mysecretbase.com/ColdFusion_and_Unicode.cfm

Also, storing a resume in a nvarchar column might be a tight fit....

I was using a varchar(5) and inserting five characters into the field.

I am now thinking that either ColdFusion, SQL Server, or the JDBC/ODBC driver must be doing some conversion...

OK, so the ASCII and UNICODE functions don't reveal what is actually stored in the column.

What I am doing is inserting these values into the database with ColdFusion,...

The conclusion mentions cost as being a factor, but costs are not listed in the article. How much do these products cost?

Thanks for the link. The presentation provides a lot of information to absorb, and I have to make assumptions to make up for some of the terse wording....

Thank you. I guess what the question comes down to is whether it is better to have indexes in place before a massive insert, or whether it is better to build...