Different FillFactors for different partitions?

Why is fillfactor not a recognized option on alter index rebuild
partition. I'm partitioning my data by month, I'd like to set the
fillfactor to 100 for old partitions, but put a lower fill factor say
60% for this month so that I don't have to worry about page splits for
incoming data. I'm in a realtime etl environment, so a sliding window
is not going to do it. Please advise.
ALTER INDEX IX_MyIndexKey ON dbo.tblMyTable REBUILD PARTITION=91
WITH (FILLFACTOR = 60,
PAD_INDEX = ON,
ONLINE = ON);
GO
Msg 155, Level 15, State 1, Line 2
'fillfactor' is not a recognized ALTER INDEX REBUILD PARTITION optionIt's a known issue:
https://connect.microsoft.com/SQLSe...=2420
25
Please cast your vote so that it will move up on their priority list.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"dba" <bryanmurtha@.gmail.com> wrote in message
news:1186660216.374134.172540@.g4g2000hsf.googlegroups.com...
Why is fillfactor not a recognized option on alter index rebuild
partition. I'm partitioning my data by month, I'd like to set the
fillfactor to 100 for old partitions, but put a lower fill factor say
60% for this month so that I don't have to worry about page splits for
incoming data. I'm in a realtime etl environment, so a sliding window
is not going to do it. Please advise.
ALTER INDEX IX_MyIndexKey ON dbo.tblMyTable REBUILD PARTITION=91
WITH (FILLFACTOR = 60,
PAD_INDEX = ON,
ONLINE = ON);
GO
Msg 155, Level 15, State 1, Line 2
'fillfactor' is not a recognized ALTER INDEX REBUILD PARTITION option