What is the best method to identify duplicate records in a table?
In this case there is approx 1.5 million records and i need to look at
each field.

your help will be appreciated.