If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increme... | Hacker News

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

		jamwil 6 months ago \| parent \| context \| favorite \| on: Congratulations on creating the one billionth repo... If a SQLServer instance is killed unceremoniously it adds 1000 to the pk increment.

jiggawatts 6 months 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!

jamwil 6 months ago | [–]

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

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