Thank you Grant Fritchey!

I don't have Web Service RDS, but I ran below SQL Statement on local SQL Server  and got information as the file.

SELECT dl.deadlockgraph

FROM

(

SELECT dl.query('.') AS...

Here's a very thorough article on BULK INSERT. In general, it can be faster for large data moves. It may use less locking. It may use fewer log...

<li style="list-style-type: none;">

1. For deadlocks you can look into the system_health Extended Event session to find more occurrences. I have an example query here on this blog...

You could automate the backup/restore process with a bit of scripting.

If you have enough space on your 'data query' server to host two versions of the database, you could...

Lordy... some designer needs a serious pork chop lesson on the first rule of the First Normal Form. <facepalm>.

The only way you're going to be able to fix this...

> how to optimize the query from the table design to create index and statisctis ? <<

As Jeff said, you can't, not with the data in its current form.

You...

<li style="list-style-type: none;">

1. Then replication or backup/restore would seem reasonable options.

<li style="list-style-type: none;">

1. Probably. It would require some analysis and design work to decide on how best...

Are there lots of different tables being changed? If so, the answer is likely to be one of

<li style="list-style-type: none;">

1. Replication

<li style="list-style-type: none;">

1. Backup / Restore

If only...

Yes, the target table has a identity column,  the said "disable"  identity column means I set the identity column No under the table's identity specification.

actually, the indentity column...

Yes, the target table has a identity column,  the said "disable"  identity column means I set the identity column No under the table's identity specification.

actually, the indentity column is not...

You do realize that by setting your database to SIMPLE that you just broke your logfile chain if one existed, right?

Shifting gears back to the problem at hand.... what...

Thank everyone for your kind and good advice! thanks so much!

Frederico .... maybe you're onto something.

Your query has multiple references to ftbid01 which obviously should be to 01, 02, 03, ...

The outer apply could be a cross apply, or...

if I got it correctly the dynamic requirement is that its not the content of the field that is being updated but rather that the field it is being...

Please kind see my...