And ofcourse you can create a CHECKSUM computed column which is calculated from all other fields. So you can determine all the duplicate records easily, they are all give the...

I'm using that method (creating a unique index) for already existing tables. I mean without changing the original table.

If you able to change / redesign your table you can add...

ted.pin (4/18/2008)

---

If the data set is large, and there are no FKs defined on the table, a faster method might be to SELECT INTO a physical table (which will create...

Sure. I fixed the artice now.

Thank you.

God! What did I think when writting this query! 🙂

Anyway, why Query Analyzer gives that results for these queries?

46% : select * from myTable where id = (select max(id) from...

I understood your point, you're completly right, thanks a lot.

I see the first one, but why the second query works as a INNER JOIN? I use a LEFT JOIN.

As I know (I'm not an expert btw) the difference is...