Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Fill factor

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-10 : 13:27:51
S writes "Hi,

I am currently using SQL SERVER 7.0 with no service pack on windows NT 4.0 Sp5. We have a database with too much of an activity ie many inserts etc. I have added primary key to some of those tables. Do i need to change the fill factor for those tables? If so , what is the suggested fill factor for tables with high activity? I also have non clustered indexes on these tables. Do i also need to specify a different fill factor for the non clustered index as well ?"
   

- Advertisement -