Hm, this is a very good topic, and most answers make sense.

But the last one with the where clause for all inserts is nonsense. You cannot "enforce" uniqueness by telling yourself to always use a where clause.

I was also caught by the calculated column answer. That is an interesting technique I had not considered, but which is indeed a viable solution.