You may have to drop the index and re-create it, i.e.:

DROP INDEX MyTable.IX_MyTable
GO

CREATE INDEX IX_MyTable ON MyTable(Col1, Col2...)
WITH FILLFACTOR = whatever
GO



-----Original Message-----
From: Ken Kaufman
[mailto:mssqldba-ezmlmshield-x12551904.[Email address protected]
Sent: Saturday, 28 April 2007 3:07 AM
To: LazyDBA Discussion
Subject: Reindexing a Partition with a fill factor

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>





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page