This is a good explanation of the contention problems when using sequential keys.  This problem has been a problem with SQL Server since the days of SYBASE.

I've experienced this with...

• This reply was modified 3 weeks, 5 days ago by bill.rogers 55030.
• This reply was modified 3 weeks, 5 days ago by bill.rogers 55030.