As i was writing this blog on Surrogate and Natural keys i started wondering... what was your most unorthodox system design decision? be it SQL server, Sharepoint, CRM, Network, etc...
Mine was droping the complete codebase of a project in it's 3rd iteration and starting over.
I did something like that, a project I worked on for 2 weeks but felt it wasn't quite right. I had a glimmer of an idea on Thursday but couldn't flesh it out. I didn't work on it Friday, then went into the office on Saturday and Sunday and knocked it out. DB, app code and UI all redone in about 18-20 hours.
The really unorthodox thing about it were my tables...no surrogate keys. :) I had one table with 5 or 6 columns, and they were all part of the primary key. Most of the tables were like that, very few non-key columns. I was in Chris Date mode back then, not long after I wrote my infamous Identity column article, and this app just happened to fit theory pretty well.
I wouldn't do it that way today though.
