3 ms·
If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increment.
by jamwil 1y ago
If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increment.
- jiggawatts 1y agoI'm trying not to imagine the poor SQL Server that has crashed one or two million times and hence pushed the ID values into the billions!
- jamwil 1y agohaha—somewhere out there it’s crashing right now. Keep it in your thoughts.