Gary Varga (10/26/2016)
BWFC (10/26/2016)
...Maybe a longer date should have been chosen but when 01/01/2020 was picked, no one could have even remotely foreseen what happened subsequently and the situation in which we've now found ourselves.I am not convinced that an arbitrary date would ever be a reasonable decision. I would have argued this one all day. In this scenario, why not just use the maximum? Or even the minimum? (as NULL could not be used)
Again, you're preaching to the choir đŸ™‚ I don't know why they didn't go with the maximum date. Using the minimum would certainly have caused problems though. At that stage, it wasn't a decision into which I had any input. It actually made our lives, at the coalface as I was then, considerably easier when the indefinite dates were brought in.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537