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 2 days, 7 hours ago by bill.rogers 55030.
• This reply was modified 2 days, 7 hours ago by bill.rogers 55030.