Home Forums SQL Server 2008 SQL Server 2008 Administration Fragmentation size RE: Fragmentation size

  • December 26, 2012 at 3:53 pm

    #1571700

    zi (12/26/2012)

    Dear Friends

    1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.

    2-what is the relationship between re-build or re-organise index by log file.

    Thanks lot

    These are actually interview questions.... important interview questions that every DBA should know by heart. The fact that you're posting these questions means you really need to spend some time practicing being a DBA before you answer another ad for the position. And, no... I'm not trying to be mean here. Call it "tough love" for someone looking for a job as a DBA. Buy yourself a copy of the SQL Server Develop Edition, install it on your laptop or home computer, and hit the books.

    You might also want to learn how to Google for such answers instead of relying on the kindness of others who might not actually know the answers to your questions. 😉

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