SQL Reindexing

Discussion in 'SQL Server' started by Kinnari, Jul 10, 2007.

  1. Kinnari

    Kinnari New Member

    Jun 18, 2007
    Likes Received:
    Trophy Points:
    I work on SQL 2000. I fired a command DBCC DBREINDEX (database name,10).
    SIze of the database increased. Then i fire the same command with fill factor 0. Still the size increased. The size was almost double after the first command. it was increased by 2 GB after the second command. Any once tell me why the size has been increased. and what can i do now? Thanks - kinnari

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice