Description
Cleaned and error free data; this is the common phrase that we normally listen from most of the data warehouse users. So to make this statement true, SQL Lion <http://www.sqllion.com/> team has come up with a tool named “Duplicate Remover”.
This tool will search for the presence of duplicate records (redundancy in tables at record level) as per the selected databases and tables from SQL Server instance, and list them. After checking the redundant tables, the user can customize the delete operations to limit the deletion to certain tables.
This tool comes in two versions, for SQL Server 2005 and SQL Server 2008. Both the versions are given below. Download it for free.
For SQL Server 2008:
Minimum Configuration -
· .Net Framework 3.5 Service pack 1
· SQL Server 2008

For SQL Server 2005:
Minimum Configuration -
· .Net Framework 2.0
· SQL Server 2005

To see details about the mechanism of deleting redundant rows from a table safely, visit the link “Delete Duplicate Records“ below.
<http://www.sqllion.com/2009/05/delete-duplicate-records/>