How do I... Identify and delete duplicates from SQL Server tables?
Source: Susan Harkins
Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. The good news is that finding and deleting duplicate records in Microsoft's SQL Server isn't a difficult task. However, determining just what constitutes a duplicate can be a bit tricky. Susan Sales Harkins shows you one technique that can help.
This download is also available as an entry in the TechRepublic Servers and Storage blog.