Sharepoint 2010 Out of the Box features - Add Unique Key on List column

In Sharepoint 2010 now you can setup unique key constraint on column. While creating column
select "Enforce unique values" and Sharepoint will index the field.. Bingo...