When scheduling a Rebuild Index task, as part of database optimization in a Maintenance Plan,a database may grow in size after re indexing is performed.
The value being entered (as a percentage) is being passed as the Fill Factor and not the amount to be left free. The product developers have confirmed that this is a defect in the current version of LiteSpeed for SQL Server. The fill factor value supplied to DBCC DBREINDEX is incorrect.
Re indexing uses DBCC DBREINDEX
(
table_name
[ , index_name [ , fillfactor ] ]
)
Addressed in a future version of LiteSpeed for SQL Server.
Workaround: Specify the Fill Factor you require instead of the percentage left free, or else script the task creation and manually enter the Fill Factor required.
Fixed in5.1.0.1293version of LiteSpeed
