Home Forums SQL Server 2008 SQL Server 2008 Administration fix fragmentation sql server RE: fix fragmentation sql server
shaun.stuart
SSCertifiable
Points: 7033
More actions
September 23, 2010 at 11:23 am
#1226482
John__A is correct. Don't run the update stats sp after rebuilding all the indexes because you will be replacing stats that are based on a full scan with ones that are based on a sampled scan, possibly resulting in less accurate statistics.