Hacker News new | ask | show | jobs
by jamwil 370 days ago
If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increment.
1 comments
jiggawatts 369 days ago
I'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!
link
jamwil 369 days ago
haha—somewhere out there it’s crashing right now. Keep it in your thoughts.
link