When should I use Unique IDs?

Use Unique IDs in your design when each of the following criteria are met:

• you need a unique key for a database entity
• the database key has no "business meaning"
• instances of the entity may be created by multiple contending on-line or batch functions
• holes in the key sequence are acceptable (which should always be true if the key has no business meaning).