question

MladenPrajdic avatar image
MladenPrajdic asked

What was your most unorthodox system design decision?

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.

databasedatabase-design
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
robvolk avatar image
robvolk answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.