There are many reasons for the gaps in identity columns,it may be due to the deletion of record,hard reset of identity column
or due to the roll back of the transaction or else due to shutdown of the sql server.
Below links explain them in detail.
- Identity column Gap
