Forum Replies Created

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

  • RE: Strange Behavior with (nolock)

    GilaMonster (10/22/2013)

    josh 92884 (10/22/2013)

    CHECKDB found 0 errors and repaired 0 errors.

    :sick: I didn't say run it with a repair option...

    I ran:

    DBCC CheckDB (mydbname) WITH NO_INFOMSGS, ALL_ERRORMSGS

    The results I...

    October 22, 2013 at 9:26 am

    #1660587

  • RE: Strange Behavior with (nolock)

    thanks Gila

    CHECKDB found 0 errors and repaired 0 errors. Took about 32 minutes on a 77GB db with reasonably modern hardware.

    I hear you on NOLOCK. Based on what I'm reading...

    October 22, 2013 at 8:12 am

    #1660543

  • RE: Strange Behavior with (nolock)

    Nothing groundbreaking in the plan. It shows a Clustered Index Scan -> Compute Scalar (I think it's resolving *)-> SELECT.

    The Clustered Index Scan get 100% of cost. Estimated rows...

    October 21, 2013 at 6:00 pm

    #1660344

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