Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning DB log growth issue RE: DB log growth issue

  • November 25, 2014 at 7:30 pm

    #1760951

    qew420 (11/25/2014)

    My next Maintenance plan is schedule to run in two weeks so I will review the links, articles and scripts you all provided and hopefully come up with a solution before next maintenance plan

    Thanks all

    Happy Thanks Giving 🙂

    What is the backup plan that you have with this?

    Also, I agree with the others... using a built in maintenance plan will defrag all of the indexes... whether they need it or not. Most indexes whose first column is based on a column from the table that is ever increasing and immutable will almost never get fragmented just in normal use. That could cover the clustered indexes (which is the table data itself) of some pretty large tables.

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