SQL Server Rebuild Indexes


[FinalBuilder Professional Edition]


The SQL Server Rebuild Indexes action specifies that indexes on tables in the target database should be rebuilt by using the "free space" percent value as the inverse of the fill factor. For example, if free space percentage is 30, then the fill factor used is 70. If a free space percentage value of 100 is specified, then the indexes are rebuilt with the original fill factor value.


For more information on the sqlmaint tool see: http://msdn.microsoft.com/library/en-us/coprompt/cp_sqlmaint_19ix.asp


To set the location of SQLMaint see SQL Server Options