A table with a varchar column that has date and other value types too.
A query with a simple CONVERT DATETIME
Conversion failed when converting date and/or time from character string.
Crashing. Over and over again. I start to call it X-Files. Until I read THIS. Not only I know why it happened (and sortof feel like SQL is "stupid" :D) but I get an interesting idea to work around the issue.