>>Shows the fill factor that specifies how full each index page can be. If a
Hi, what's database's default factor?0 or 100%. Can be configured for all databases using sp_configure. For
more information see fill factor option in the SQL Server BOL.
HTH
J
"js" <js@.someone@.hotmail.com> wrote in message
news:elVVFmUYFHA.3132@.TK2MSFTNGP09.phx.gbl...
> Hi, what's database's default factor?
>|||Thanks Jerry,
When adding index, what is the factor to specify?
CREATE NONCLUSTERED INDEX IX_Commission ON dbo.Commission
(
UID
) ON [PRIMARY]
GO
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OSRSeoUYFHA.2348@.TK2MSFTNGP14.phx.gbl...
>0 or 100%. Can be configured for all databases using sp_configure. For
>more information see fill factor option in the SQL Server BOL.
> HTH
> J
> "js" <js@.someone@.hotmail.com> wrote in message
> news:elVVFmUYFHA.3132@.TK2MSFTNGP09.phx.gbl...
>|||The answer is "it depends". A lower fillfactor reduces fragmentation of the
index and a higher fillfactor reduces the size of the index. As a general
rule more read activity = higher fillfactor more write activity = lower
fillfactor.
"js" <js@.someone@.hotmail.com> wrote in message
news:uJ8GstUYFHA.4036@.tk2msftngp13.phx.gbl...
> Thanks Jerry,
> When adding index, what is the factor to specify?
> CREATE NONCLUSTERED INDEX IX_Commission ON dbo.Commission
> (
> UID
> ) ON [PRIMARY]
> GO
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OSRSeoUYFHA.2348@.TK2MSFTNGP14.phx.gbl...
>|||Usually, the default fill factor value is appropriate for the majority of
indexes. You might find the topic 'Fill Factor' in SQL Server Books Online
useful for a general understanding of how fill factor is used.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"js" <js@.someone@.hotmail.com> wrote in message
news:uJ8GstUYFHA.4036@.tk2msftngp13.phx.gbl...
> Thanks Jerry,
> When adding index, what is the factor to specify?
> CREATE NONCLUSTERED INDEX IX_Commission ON dbo.Commission
> (
> UID
> ) ON [PRIMARY]
> GO
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OSRSeoUYFHA.2348@.TK2MSFTNGP14.phx.gbl...
>
