3 ms·
Long time ago we ran several large insurance websites, fairly standard SQL Server backend. Once day I got into work and a slightly panicky dev said "We need to
by adamauckland 4y ago
Long time ago we ran several large insurance websites, fairly standard SQL Server backend.
Once day I got into work and a slightly panicky dev said "We need to change the primary key on all the tables"
It was using an int and at the current rate of data entry, was going to blow the maximum record number in a couple of days.
- hungryforcodes 4y agoMust have been in the Jerassic period of MS SQL Server primary keys...
- foobarbaz33 4y agoIf you choose a 32-bit integer for your PK it can only address about ~4 billion records. That was true 1000 years ago, and will be true forever until a black hole swallows everything and changes the laws of reality.
- bluGill 4y agoForget how many angels can dance on the head of a pin, the real question is can God change the value of pi, or can God make 32 bit integers larger than our current max? In both cases what it means to math is more Interesting than any yes/no.
- jerrre 4y agoyou could take this anecdote as a proof for how rarely these things happen
- adamauckland 4y agoYeah, that's true, the one time in 25 years.