Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   SQL Reindexing (http://www.go4expert.com/forums/sql-reindexing-t5176/)

Kinnari 10Jul2007 11:50

SQL Reindexing
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

All times are GMT +5.5. The time now is 15:50.