1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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