I have a web online table that is inserted about 1500 record one day. Each night, a DST is running to pull all data to anther database. How to set fill factor on a one column index to get the best performance? Current fill factor is 80%.
I'm not really into the fill factor thing. In fact I'm still learing my way in SQL Server.
Also, I really don't know if setting a fill factor would benefit your particular case. However, as far as I know, you should be able to determine the fill factor (0-100) of a particular index by using the ALTER INDEX command.
Not really sure if this was the answer you were looking for. There's the chance that I didn't understand your question.
You are having performance issues with just 1500 records per day?
If I may - the nature of the records inserted bares some scrutiny. We had a guy on recently (I forget who) who's records averaged 4KB per record. As such I agree - we need to at least see the DDL to get an idea of what might be inserted.
We could also do with knowing if rows are likely to be updated regularly (and if those updates are likely to dramatically change the size of the rows).
...and finally - we need to know (as MCrowley says) what the reindexing processes are for this table.
@OP - there is a lot of factors that determine the optimum fillfactor. Please provide the information requested