Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Back around 2000, a site I was working on suddenly started producing unexpected results because I'd left out an ORDER BY. It was using SQL Server, and apparently that had decided to rearrange its stuff on disk. The data in question, which had been coming back in order of insertion, started coming back in an entirely different order; as I recall, it started a couple of thousand records in, with the stuff at the "beginning" turning up much further down.
Luckily I knew that "different order to the one you expect" is usually, in fact, "unordered but giving the impression of having some kind of order as an artefact of the underlying implementation" so I was able to quickly diagnose and fix it. It would've been rather embarrassing had it made it into production