Many developers reporting that there is a bug in SQL server 2014 in which the id columns with auto increment feature having a big jump every time the server is restarted. Microsoft says that this is a feature rather than a bug. Some developers could live with it, but many others find it very frustrating especially when that column is to be showing in the client application, for instance if this number is used to provide a sequential invoice number. As a developer, you will get a endless stream of support calls about these unexpected jumps. Continue reading “Identity column big jump solution for SQL server 2014”