Go4Expert

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 07:17.