about this topic , do you have any other solution? thanks!

Thank you Jeff Moden for you kind help!

you said "Understanding that there are at least 6 different Insert/Update patterns and the 4 of them are seriously affected by "ExpAnsive" updates....

I used SQL profile to trace SQL Statement and found user use insert bulk to insert data for a table, but the sql statment is too long (over...

Thank you, this article of the link...

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...