SQLSACT (8/15/2012)
Given all of this, is it safe to say that, where possible, make you indexes unique?
You should only make an index unique if the data is unique and guaranteed to stay so through your business rules. But yes, if the data is unique, make the index unique.