Thread: SQL Reindexing
View Single Post
Newbie Member
10Jul2007,11:50  
Kinnari's Avatar
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