1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

SQL Reindexing

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

  1. Kinnari

    Kinnari New Member

    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