Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Re-org option for index where pagelock is disabled RE: Re-org option for index where pagelock is disabled

  • July 28, 2015 at 7:55 am

    #1815421

    Sagar-636902 (7/28/2015)

    I am looking for the better option, what is the best way to maintain the Re-org when allowpagelock=0. we have about several indexes which are less then 4m page counts. I see we can do re-build but some situation we can't do re-build because of blocking. is this good idea,if we turn on allow page lock while doing re-org and put it back after it done?

    Thanks

    Sagar

    Just my humble opinion...

    I'm not sure why people ever turn page lock off. To me, it's a "patch" for a larger problem rather than actually fixing the larger problem.

    Back to your problem...

    Obviously, whatever disallowing pagelocks did for you would not be present if you reenable page locks for the reorg. Other than that, I see no reason why you couldn't do as you suggest.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)