[rileymat2]

Not always, this article describes the problem: https://learn.microsoft.com/en-us/troubleshoot/sql/database-...

[hobs]

Exactly, with one big insert its better to have a sequential value, for many small ones its often better to not.

As with all databases, measure before you cut.