Removing Duplicate Records using SQL Server 2005

Tuesday Jul 29th 2008 by DatabaseJournal.com Staff

Removing duplicate records from tables is sometimes an arduous task, especially if the source table does not contain a primary key field. Here’s how you can take advantage of a new SQL Server 2005 feature to remove duplicates quickly and efficiently.

[From TechRepublic]

Duplicate records can occur numerous ways, such as loading source files too many times, keying the same data more than once, or from just bad database coding. Having a primary key on your table (and you always should have one) can will in the removal of the duplicate records, but even w/ a primary key it is never a fun task to have handed to you to complete.

The article continues at http://blogs.techrepublic.com.com/datacenter/?p=420

Mobile Site | Full Site