Post reply

Impact of running dbcc cleantable in sharepoint database

  • June 27, 2017 at 10:41 am

    #324245

    Hi,

    is there any impact in running dbcc cleantable in the sharepoint database? I found an index which has grown very large in sharepoint db and rebuild index fails as it demands more size. Can't remove the dbs from checkdb maint, so looking for a feasible solution.

    DBCC CleanTable definition says - Reclaims space from dropped variable-length columns in tables or indexed views.

    well, how to check additionally if there is any variable-length columns exist in the tables or indexed views?

    Please suggest with your opinion.

    Thanks.

  • June 27, 2017 at 7:20 pm

    #1948480

    Your handle has the abbreviation "DBA" in it.  You should know this or know how to find it. 😉

    --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)

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

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