Hi there
As a matter of course in SQL Server, you should be running dbreindex or indexdefrag on a weekly basis. I have an article coming soon showing the movement of pages after these routines are run. As for table sizes, run dbcc showcontig and have a careful looksie re fragmentation. I tend to ignore anything less that 1000 to 5000 rows (dending on avg row size), you will find that no matter the setting showcontig may remove terrible extent fragmentation due to mixed extent alloc, and in reality,the physical pages are in extents that are side-by-side. Id be more concerned about SQL at a higher level, and run the defrag commands on a regular basis.
Cheers
Ck
Chris Kempster
http://www.chriskempster.com
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"