Fill Factor

How do i find out how much fill facot has been spcified in given table?.Praveen (apveen@.gmail.com) writes:

Quote:

Originally Posted by

How do i find out how much fill facot has been spcified in given table?.

On SQL 2000, sysindexes.OrgFillFactor may give you what you are looking for.

On SQL 2005, use sys.indexes.fillfactor.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql