Raj

So do you only ever insert one row at a time?  Is it during the insert itself that you experience the poor performance, or during the duplicate checking?

John

David

You will need to build a script dynamically.  Something like this rough-and-ready effort, which generates a script that returns all rows where at least one of the columns has a...

Raj

So you're doing this once for every row you're inserting into the table?  Are you using a cursor or a WHILE loop to do that?  I think this is probably...

Anchelin

OK.  Can you please put a PRINT @Query3 statement just before the EXEC command and post the result of that.

Thanks

John

Probably what you need, then, is to create a trigger in the table that checks the time of the previous insert, and if it was less than ten minutes ago,...

Anchelin

How many columns are in the result set when you run sp__DBBackupInfo on the remote server?

John

Raj

I'm sorry, I don't know anything about Materialized views in Oracle so I can't advise you on that.

If you had a unique constraint on CUST_PRODUCT_ID, ATTRIBUTE_ID and DATA then that...

Would this not work?

SELECT Titleid AS tit FROM title WHERE Titleid=11

John

What are the circumstances under which you wish to discard the less recent value?  Is it when it is less than an hour before the previous one?  Or is it...

Raj

OK.  It looks as if your database design here is not ideal.  There is no primary key constraint on the table.  Is there a column (or combination of columns) that...

Anchelin

Perhaps you ought to include a "USE DBName" statement at the beginning of @Query2.  If that doesn't work, please post the result of this query:

USE DBName

SELECT COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE...

So you have several temp tables, all with the same structure, but each named according to a user in the database?  My advice would be to normalise your design so...

Raj

Please will you post the table DDL so that we can see what constraints you have on the data (primary keys and so on).

Thanks

John

Anchelin

You need to substitute the actual names of the columns in tablename (why do you have that enclosed in quotes in your script?) otherwise it will look for columns named...

Mike

No worries.  That kind of linking table is called a junction table, and it's the kind of database design aspect that would have taken me ages to think up on...