reset fill factor back to server default

ok, time using maintenance plan rebuild our indexes. decided change "free space per page" option 10%. fine @ time. several things have changed , have maybe 1 or 2 tables fill factor 90. although problem , maintenance plan changed indexes 90 , if select "reorganize default server setting" still zero, not change fill factor back. kind of sucks. tried update sys.indexes didn't work(haha). seems way them default drop , create of them.

there way set fill factor default next time our alter index maintenance plan runs changes fill factor 0 (current server default).

thanks,

hello,

you can use dbcc dbreindex reseed fill factor of index; select index, loop through cursor , execute dynamic sql statement start dbreindex indexes.

example:

use [adventureworks2008]

go

 

dbcc dbreindex ('person.address', '' , 70)

 

select name, fill_factor

from sys.indexes

where object_id = object_id('person.address');

 

dbcc dbreindex ('person.address', '' , 90)

 

select name, fill_factor

from sys.indexes

where object_id = object_id('person.address');

---

olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de

SQL Server  >  SQL Server Database Engine