There's a great article by Lynn Pettis that covers the topic very well.

I suggest that you take a look:

http://www.sqlservercentral.com/articles/T-SQL/67898/

Wow! Thanks Gail, I'm trying immediately on my production server. :hehe:

Would you also recommend (as a fellow expert) turning on these switches?

exec sp_configure 'Auto...

That's why I never get emails from strangers.

Uhmmm... wait a moment: I don't even get them from people I...

Steve, I can just say that you are running this community outstandingly and I'm proud to be a member.

The reasons why you are running SSC are up to you,...

Should we name it HAL 9500 (posts)?

Double post

I did a quick search:

Informix latest version should be 11.5 (it's a long time since I last worked with it :-))

You need to install the CSDK package, that should contain...

You need to install the OLEDB provider for Informix. I don't remember where it comes from, but I remember there's a tools CD that contains the OLEDB provider (and many...

The duplicates can only be in the data you are inserting.

Try to query those rows grouping for the primary key having count(*) > 1.

There's a comparison in the "IN" clause, so you have to define explicitly the collation you are using both in the subquery select list and outer query where clause.

Try this:

WITH...

The UPDATE is enough. There's no need for the EXISTS test, it's just doing things twice and slowing down operations.

The two queries do different things, but I guess you are trying to detect duplicate records.

Putting "distinct" records into a new table involves copying a lot of data, so I...

When STATISTICS TIME is set to ON you get time stats for each statement in the batch, so it might print a huge number of statistics.

This is not the case...

I don't think this is a good Idea, Mike. The code you put in the transformation script is run for each row in the source table, so it would have...

jcrawf02 (11/23/2009)

Is that all you ate? I notice no side...