You could add code to check for a record's existence, and only INSERT if it is not already there.

That will prevent the error, but does not answer the question of...

BODS is similar to SSIS. Initially you say the problem is slowness, but later it's connection failing. Are there 2 different problems ?

Is there a problem with the source or...

• This reply was modified 4 years, 7 months ago by homebrew01.

Hi all, I used such script for finding unused indexes in my DB:

It was interesting for which period I received such information. I read that this information updated each...

Was it updated with a manual UPDATE EMPLOYEES SET FIELD_A = 'ABCDE' ?

If so, a suggestion for future manual updates, always put manual updates in a transaction, so you can...

You could try posting here:

https://code400.com/forum/forum/iseries-programming-languages/sql

Not a lot of traffic, but a few very knowledgeable people.

Does the target table on the "slow" server have many indexes more than the "fast" server"

4T in a few seconds !?!?

Does SKA have an index on StockKeepingId and AttributeNumber ?

Does RMD have an index on RmaDocumentId and RmaDocumentAttributeId ?

Have you looked at an execution plan ?

I see no need to use a 4 digit year here.  Almost no businesses go back and analyze 100-year-old data, so there's no ambiguity.  Even more so if you get...

Are you able to take Differential backups ?

The tools I have used in the past have had a free trial period of several weeks or a month. Try before you buy.

We have a 3rd party tool, Datto, that does server "snapshot" backups. SQL registers it as a database backup, although it did not take a real backup. I found it...

• This reply was modified 4 years, 10 months ago by homebrew01.
• This reply was modified 4 years, 10 months ago by homebrew01.

This seems to almost work, but the counts are a bit higher than the actual number of 'JOIN' strings.

No time to improve it right now, but might be "good enough"...

The very first recommendation in such...

What is the purpose, use & "priority" of the target server ? Does it already have data, or is it a copy into an empty database ?

Is this a 1...