Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning why is my fragmentation so high on non-leaf index levels RE: why is my fragmentation so high on non-leaf index levels
humbleDBA
Hall of Fame
Points: 3490
More actions
January 25, 2008 at 2:44 am
#771627
Just a question to ask...you're not shrinking the data file after the index rebuild or have autoshrink on?