Hello Professional,

I would like to ask one quick question regarding Maintainance Plan ->
Rebuild Index Task.

I have created Maintainance Plan and in that I used "Rebuild Index Task" to
rebuild the index and I set free space per page percentage to 20% that means
Fillfactor would be 80% right.

But when I generate the script, Maintainance plan use 20% as a fillfactor
instead of 80%... see below.

USE [Testing]
GO
ALTER INDEX [MSmerge_index_2105058535] ON [dbo].[Order] REBUILD WITH (
FILLFACTOR = 20, PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF,
IGNORE_DUP_KEY = OFF, ONLINE = ON )

I was put under the impression that Free Space was the oposite of Fill
Factor. Meaning if I wanted to have an index rebuild with 80% fill factor I
would fill out the field "Change free space per page percentage to" to be
set to 20.

Please advice.

Thanks

Hi Noor,

Yes, when you set free space per page percentage to 20% it means that the
Fill Factor should be 80%.

Which version of SQL Server are you using?
Have you installed the latest Service Pack?

If you are using SQL Server 2005 install SP3
(http://www.microsoft.com/downloads/d...isplaylang=en),
reboot the machine (if necessary) and try again.

I have just tried it and now the generated script is correct.

Cheers

--

Artemakis Artemiou, SQL Server MVP
http://aartemiou.blogspot.com

This post is provided "as-is" and confers no rights.


"Noor" <naissani (AT) hotmail (DOT) com> wrote

Thanks Artemakis


"Artemakis Artemiou" <do_not_send_spam> wrote