Originally posted by DaPi
. . . and then you realise you've been running the server with the wrong date . . . (Yes, I've seen it happen.)
In the case of a lookup table though, I'm prepared to abandon my not-so cherished principles on synthetic keys for two reasons ...

  • There will almost certainly be no other tables referencing the PK, so cascading updates are no problemo
  • I'd probably be looking for the fastest possible date-based access, which means an IOT, and date would have to be part of the PK to get the benefit