I have a project where I need to load in a few million
text files to one of two tables. I am using a primary
key that is assigned via a stored procedure routine
similar to the one used in TasTrade (newid()).

The first file contains 1.2 million records and after
22 hours it is only about 1/2 complete.

Would it have been better to not set NEWID() as
the default value and used a different technique?