NOTE: This post has been re-visited in Finding duplicated data across one or more columns in a database table
Information gleaned from Microsoft KB article: How to remove duplicate rows from a table in SQL Server
When you allow duplicated rows in a database that aren’t expected and shouldn’t be allowed, it’s a flag saying that you need . . . → Read More: Finding duplicate rows in the database
