Knowledge Base.

Here I will share my experiences on any other subjects on computer technologies, on life, on anything!...

Running Bulk Updates Faster using DML Merge.

Friday, February 12, 2016

Currently I have been having problem with running Update on a big scale tables. It runs awfully terribly slow. Once tried creating a new table with the updated information, and then truncating table and inserting the data from the new table but it is a hastle. I know there must be a way. Finally I found this site ( where he tested all the possible solutions. Without going any detail, here is the best solution to update a large scale table with WHERE condition.
...Click here for more

© 2024 -