Ask Learn
Preview
Please sign in to use this experience.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
There have been several times when I needed to ensure that we could understand the changes of data overtime. This is inline with the idea of never deleting data; however, in keeping a full audit history you can more deeply understand user behaviors. Or, if you need to have data retention for legal issues, this is also a pattern that could make sense.
Over ten years ago now, I moved from auto-increment integers to GUID’s; and I have never looked back. There are a number of reasons why I feel that it is much easier for computers systems and humans to use GUID’s to identify tuples; check it out!
Please sign in to use this experience.
Sign in