Answer the question
In order to leave comments, you need to log in
Why did the size of the mdf file grow when indexes were rebuilt?
Database size before operation ~4 GB
Rebuilt indexes on all database tables with the command:
ALTER INDEX ALL ON @TableName REBUILD WITH (FILLFACTOR = 10, SORT_IN_TEMPDB = ON)
Answer the question
In order to leave comments, you need to log in
все это дело повязано с опцией FILLFACTOR, глянте чего там MSSMS отправляет на сервер и можно почитать про описание коэффициента заполнения
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question