Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increment.


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!


haha—somewhere out there it’s crashing right now. Keep it in your thoughts.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: