InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 03:10:04 GMT20http://www.sqlservercentral.com/Forums/Topic740829-146-1.aspxJoe is correct...Additionally, if the table is HEAP (no cluster index) then ur fragmentation not remove.The above statements is true put the cluster index and drop it then ur fragmentation removed.(As per MS a table must have cluster index)Wed, 24 Jun 2009 22:35:44 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic740829-146-1.aspxCheck the size of the table as well. For smaller tables, rebuiding may not remove fragmentation.Wed, 24 Jun 2009 03:07:27 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic740829-146-1.aspxAfter having index rebuild, the indexes fragmentation is still very high, why ?I used Maintenance Plan and SQL Agent Job to do index rebuild and used the following SQL statement to find out the indexes fragmentation :SELECT TOP 10 a.index_id, name, avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID(N'Production.Product'), NULL, NULL, NULL) AS aJOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id AND (name IS NOT NULL)ORDER BY avg_fragmentation_in_percent DESCAny ideal ?Wed, 24 Jun 2009 02:58:56 GMTonlo