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 option
It's a known issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=242025
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.googlegro ups.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