Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: Update Statistics High and locking

    Hi,

    2 Questions

    a)Can "set isolation to dirty read " read a table while "update statistics high " is in progress on that table.

    b) Can you run multiple "update statistics high" statements on different tables at the same time (same database).


    Many Thanks
    TC

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Update Statistics High and locking

    Originally posted by tcoyne
    Hi,

    2 Questions

    a)Can "set isolation to dirty read " read a table while "update statistics high " is in progress on that table.

    b) Can you run multiple "update statistics high" statements on different tables at the same time (same database).


    Many Thanks
    TC
    Hi TC,

    The answer to your questions -

    a) Yes you can read a table when isolation is set to read mode & update statistics high is in progress for that table.

    b) Yes you can mulitple update statistic high on diff. tables at the same time for the same database
    eg.
    update statistics high for table customers;
    update statistics high for table orders;


    Regards,

    lloyd

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Re: Update Statistics High and locking

    Many Thanks.

    TC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •