use this : DBCC SHOWCONTIG(tablename)
In the results check for the logical scan fragmentation, which ideally should be 0.01%
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."