|
|
Posted by Erland Sommarskog on 07/14/06 21:57
Praveen (apveen@gmail.com) writes:
> 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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|