Hilton Hotel has had to restart BigInts twice now across the world for rentals.
On Fri, Apr 8, 2016 at 3:16 PM, Ted Roche <[email protected]> wrote: > On Wed, Mar 9, 2016 at 6:17 PM, > <[email protected]> wrote: > > > ...I did > > NOT want to use auto-increment keys in the tables because I wanted to > have > > more control over them during data-entry, so basically, I can create all > > kinds of records and then at save time AND ONLY THEN do I want to store > the > > actual data (and that's why AUTOINC keys wouldn't work). > > Fun Fact: If you were to create 1000 PKs a day and throw them away, > and you worked 365 days/year, you would run out of 4-byte integers in > 11,767 years. > > Of course, if you were to create GUIDs, the universe would likely end > first. > > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJSUtfJvxZ3xF1iqbo=xf-qexrxfvvxa+hxnavdnkg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
