How can i get the current "Fill Factor" for an existing
index
Thank you !
DonUse the INDEXPROPERTY function. For example:
SELECT INDEXPROPERTY(OBJECT_ID('authors'), 'UPKCL_auidind',
'IndexFillFactor')
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Donald" <Donald.huppe@.bocenor.com> wrote in message
news:0d2101c37230$66d7ef10$a501280a@.phx.gbl...
> Hi,
> How can i get the current "Fill Factor" for an existing
> index
> Thank you !
> Don|||This is a multi-part message in MIME format.
--=_NextPart_000_0166_01C3720F.D6745550
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Check out INDEXPROPERTY() in the BOL.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Donald" <Donald.huppe@.bocenor.com> wrote in message =news:0d2101c37230$66d7ef10$a501280a@.phx.gbl...
Hi,
How can i get the current "Fill Factor" for an existing index
Thank you !
Don
--=_NextPart_000_0166_01C3720F.D6745550
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out INDEXPROPERTY() in the =BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Donald"
--=_NextPart_000_0166_01C3720F.D6745550--
No comments:
Post a Comment