Posted by Erland Sommarskog on 10/21/07 09:10

Michael Evanchik (mre224@yahoo.com) writes:
> Im trying to dedupe a table with only one field on it. The table has
> 40 million records in it. What is the fastest way?
>
> 1) create a table with a unque constraint on it insert into that
> table?

I assume that you would use the IGNORE_DUP_KEY option? Else the scheme
wouldn't work. That could very well be the fastest method.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: database to comprehensively manage anniversaries
• Prev in forum: database to comprehensively manage anniversaries
• Thread view: Re: fastest way to deduplicate a list

[Reply to this message]