Adjust fill factor to reduce fragmentation

Question

I have a non-clustered index that has ~ 1000 pages, 95% fragmentation, and a FillFactor of '0'.

I restored the index on Sunday. After a week, the index again has a fragmentation of 95% (or so). Is this a sign that I need to change FillFactor to say 80-90%?

Do I have to adjust the fill factor every week to see if I can reduce fragmentation from week to week? Is there a target level that I shoot to shoot?

Thank.

Answer 1

, . , , , .

, , . :

, ? , SQL Server. , thumb, :

* Low Update Tables (100-1 read to write ratio): 100% fill factor
* High Update Tables (where writes exceed reads): 50%-70% fill factor
* Everything In-Between: 80%-90% fill factor.