Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Percentage of Fragmentation increased after 6 hours RE: Percentage of Fragmentation increased after 6 hours
coolchaitu
SSChampion
Points: 10332
More actions
August 30, 2015 at 11:43 pm
#1823295
Dear Jeff,
Both are non-clustered indexes. I will try setting fill factor=80 or 70. Thanks sir