OK here is my point.

Lets go to the begining of this thread.

Here is what I did

1. Ran the following command

ALTER INDEX ALL ON APPOINTMENTS Rebuild;

2. Ran the following query

select index_id, avg_page_space_used_in_percent,

avg_fragmentation_in_percent

from

sys.dm_db_index_physical_stats( DB_ID('NGDEVL'), OBJECT_ID ('appointments'),NULL, NULL, 'DETAILED' )

WHERE

index_id <> 0

3. The query says that the fragmentation rate is 75 on index 1 ( I mean even after doing a rebuild why do a I get a fragmentation rate of 75 only on one particular index ? )

4. I also mentioned that the table had less than 100 rows.

5. So then why is SQl server returning wrong information ?

6. How else can we rebuild the indexes so that we get a fragmentation rate of 0 for all indexes. Is there another command out there that I don't know ( besides the Alter Index... Rebuild command )