Post reply

Update or select into

  • March 25, 2008 at 6:20 pm

    #188392

    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

  • March 25, 2008 at 6:30 pm

    #793811

    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.

  • March 25, 2008 at 6:33 pm

    #793812

    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