Default Fill factor

[Vincento Harris]

Hi
There are a lot of articles about the fillfactor.
I did change the fill factor and that did not work as intended.
How do I get back to the default fill factor
I am using sp_msforeachtable undocumented database procedure
and when the indexes are rebuilt the fill factor that shows up
in origfillfactor is the one I am trying to move away from

Your help will be appreciated

Vince

[John Bell]

Hi

Without knowing the previous values then you probably have to restore the
backup.

John

"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f*************************@posting.google.co m...

Hi
There are a lot of articles about the fillfactor.
I did change the fill factor and that did not work as intended.
How do I get back to the default fill factor
I am using sp_msforeachtable undocumented database procedure
and when the indexes are rebuilt the fill factor that shows up
in origfillfactor is the one I am trying to move away from

Your help will be appreciated

Vince

[Vincento Harris]

Thanks John for your time.....
There is a development database which is a copy of the database in
question.
The origfillfactor in sysindexes is 0 for all tables.I am assuming
this is the value assigned for the fill factor of the indexes.
Vince

Hi

Without knowing the previous values then you probably have to restore
the
backup.
John

"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f*************************@posting.google.co m...

Hi
There are a lot of articles about the fillfactor.
I did change the fill factor and that did not work as intended.
How do I get back to the default fill factor
I am using sp_msforeachtable undocumented database procedure
and when the indexes are rebuilt the fill factor that shows up
in origfillfactor is the one I am trying to move away from

Your help will be appreciated

Vince

[John Bell]

Hi

The OrigFillFactor field in sysindexes is the original fill factor used when
the index was created. It is not maintained if changed, therefore the value
before you made your changes may not have been the same.

http://msdn.microsoft.com/library/de...sys-i_76wj.asp
A fill factor of 0 will mean that the index was originally created with full
data/leaf pages, which would tend to imply that you don't expect the data to
change often/at all. If this is not the case there could be some impact on
performance.

http://msdn.microsoft.com/library/de...onfig_5k8e.asp

Rather than changing the index on-mass you may want to try the index tuning
wizard to see what it suggests, or a combination of both!!!

John
"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f**************************@posting.google.c om...

Thanks John for your time.....
There is a development database which is a copy of the database in
question.
The origfillfactor in sysindexes is 0 for all tables.I am assuming
this is the value assigned for the fill factor of the indexes.
Vince

Hi

Without knowing the previous values then you probably have to restore
the
backup.
John

"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f*************************@posting.google.co m...

Hi
There are a lot of articles about the fillfactor.
I did change the fill factor and that did not work as intended.
How do I get back to the default fill factor
I am using sp_msforeachtable undocumented database procedure
and when the indexes are rebuilt the fill factor that shows up
in origfillfactor is the one I am trying to move away from

Your help will be appreciated

Vince

[Vincento Harris]

I ran sp_configure and discovered that the config_value was 0 but on
sysindexes the origfillfactor was 100.
Thought this values should be the same!!

Vince

"John Bell" <jb************@hotmail.com> wrote in message news:<3f*********************@reading.news.pipex.n et>...

Hi

The OrigFillFactor field in sysindexes is the original fill factor used when
the index was created. It is not maintained if changed, therefore the value
before you made your changes may not have been the same.

http://msdn.microsoft.com/library/de...sys-i_76wj.asp
A fill factor of 0 will mean that the index was originally created with full
data/leaf pages, which would tend to imply that you don't expect the data to
change often/at all. If this is not the case there could be some impact on
performance.

http://msdn.microsoft.com/library/de...onfig_5k8e.asp

Rather than changing the index on-mass you may want to try the index tuning
wizard to see what it suggests, or a combination of both!!!

John
"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f**************************@posting.google.c om...

Thanks John for your time.....
There is a development database which is a copy of the database in
question.
The origfillfactor in sysindexes is 0 for all tables.I am assuming
this is the value assigned for the fill factor of the indexes.
Vince

Hi

Without knowing the previous values then you probably have to restore
the
backup.
John

"Vincento Harris" <wu*****@yahoo.com> wrote in message
news:2f*************************@posting.google.co m...
> Hi
> There are a lot of articles about the fillfactor.
> I did change the fill factor and that did not work as intended.
> How do I get back to the default fill factor
> I am using sp_msforeachtable undocumented database procedure
> and when the indexes are rebuilt the fill factor that shows up
> in origfillfactor is the one I am trying to move away from
>
> Your help will be appreciated
>
> Vince