Removing Duplicate Records using SQL Server 2005

Tuesday Jul 29th 2008 by DatabaseJournal.com Staff
Share:

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved