update mytable

set myfield = 'A' + myfield

SUre it can be tuned. A couple things.

The left join on DailyFeed20060801 ToInsertTable can be a problem. Figure out a way to write this so you don't need a left...

Sounds like homework to me.

Not sure what you mean,

Can you please post more information.

You cannot pass an array into a procedure.

Here's an article you can read:

arrays-in-sql

You can also try to pass in XML

I would suggest using xml input string instead of what you have listed, It seems your trying to do too much, and also trying to do something that sql does not...

Tell your application to stop doing that.

the stored procedure looks fine.

Look up triggers in books online.

Triggers only fire on Insert,Update,Delete.

they have to fire methods,

Instead of (insert,Update,Delete)

and

After (insert,Update,Delete)

I'm sure you can accomplish what you want in the after update trigger,

You...

your assumption that it will only scan the first table is incorrect.

a union statement runs the query against both tables regardless of what it finds.

union eliminates duplicates,

Union All shows...

Unless the select is issued by a certain user, or from a certain stored procedure, or a certain application, or a certain machine, I don't think you'll be able to...

ssis

sql server integration services

You should not be having performance issues.

If you have a partitioned view you have to make sure you have constraints on the table.

So for the Date column in each of...

Does the schema match on all the subscribers?

It appears that one of the destination tables does not match the source table. Specifically the char, or varchar size of a column is...

on insert, or issue a separate update statement,

use rtrim()

it will remove trailing spaces from the value

update mytable

set mycol = rtrim(mycol)

I do believe the seek starts from the Non Leaf, or Root pages, reading the headers, and a scan looks throu the Leaf pages. hence why it takes so much...