Update or select into

  • I have a huge table with 407 columns and around 90 million records.

    I need to run an update on 10 columns..

    updates as case, trimming, replace.....

    What do you guys suggest? Should I run select into or run an update query that runs all night.?

    Thanks

  • Definitely not select into. Break the update into batches. Don't try to update the whole table at one go.

    There was another question just like this in the last couple of days that has a lot of specific suggestions that you can use. Not sure what the exact topic was though.

  • thanks a lot this is what i was thining about. Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply