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 tedroche@gmail.com wrote:
On Wed, Mar 9, 2016 at 6:17 PM, mbsoftwaresolutions@mbsoftwaresolutions.com 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]