Post reply

Execusion Status

  • July 29, 2003 at 6:59 am

    #64969

    I ran a query to update 10 million rows. Query Analyzer does not give you any status indication until the job is done. Is there a way to find out how much it has done during the query execusion? Thank you.

  • August 1, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 1, 2003 at 8:10 am

    #468224

    I would break the update into small batches , loop it and print the status at end of each batch.

  • August 1, 2003 at 11:22 am

    #468256

    Thank you, Allen, for the input.

  • August 1, 2003 at 11:36 am

    #468263

    It may cause a deadlock, but couldn't you open another QA window and run a select count(*) based on what has ben updated. Just make sure to use the nolock hint.

    jimmY

    Work like you don't need the money.

    Love like you've never been hurt.

    And Dance like no one is watching.


    Work like you don't need the money.
    Love like you've never been hurt.
    And Dance like no one is watching.

  • August 1, 2003 at 3:06 pm

    #468289

    The update is to change value in a column. The row count will stay the same. Isn't it?

    Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

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