Home Forums SQL Server 2014 Administration - SQL Server 2014 Reduce the size of database RE: Reduce the size of database

  • September 21, 2013 at 10:17 am

    #1652142

    shiwani.plrs (9/20/2013)

    hello

    The Size of my database has been increased to 10-20 GB, although the RAM of my server is quite good, still it takes lot of time to open reports ....is there is any way to reduce the size of database other than using shrink.

    thanks

    When is the last time you rebuilt/reorged the indexes and when is the last time you updated statistics? I wouldn't mess around with anything else until those two things have been done.

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