Home Forums SQL Server 2008 SQL Server 2008 Administration Clustered Index Fragmentation RE: Clustered Index Fragmentation
Tim Weintz
SSCommitted
Points: 1622
More actions
February 24, 2010 at 2:58 pm
#1124621
Yes, changing the fillfactor will help. But I would make an argument that a clustered index probably shouldn't be used on an identity field at all. There are few exceptions, of course, but in general I think they cause more harm than good.