When you use identity column to autoincrement value on inserting data, it will always be incremented whether the data you wanted to insert was successfully inserted or not. As a result, the identity column will have some empty values. This page discusses the following problem.
Link[
^]