Home Forums SQL Server 2008 SQL Server 2008 - General Alter Index : Rebuild RE: Alter Index : Rebuild
Ant-Green
SSC Guru
Points: 113445
More actions
December 18, 2012 at 4:42 am
#1569482
Unless the de-frag has resulted in ordering which has pushed the lob and row overflow to their correct places in the index.
What is the result of MAX(LEN(column)) for all the columns within the table, and what is the datatype NameStyle?