vikingDBA (3/25/2013)
Totally agree. Page count is the main one other than avg frag %.I use > 30% and > 50 pages to rebuild. Less on either just gets a reorg.
To be honest, I wouldn't bother rebuilding or reorganising under roughly about 1000 pages, there's no real gain the table isn't large enough to have performance problems from fragmentation or low page density at that size.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability