I'm trying to reindex a single partition using the alter index
statement. The catch is I want to change the fill factor on only this
particular partition. I can't seem to get the statements to be parsed,
and there is no example of this combination on BOL. I know BOL
specifies an online rebuild can not be performed on a single partition,
but nothing about changing the fill factor. Has anyone gone through
this, and if so can you shoot me the syntax?



____________________________________________________

Ken Kaufman, CISSP

Database Administrator
P (206) 470-2730

F (206) 470-7001
M (253) 304-5045

<http://www.zillow.com>




MS Sql Server LazyDBA home page