Hi All, I want to know that why the dbcc showcontig is giving me the same results after running dbcc reindex. I have sql server 2000 with sp4. Thanks
How large is the table, how many rows, how many data pages? Small tables are held on shared extents and this means they have scan densities of things like 33.3%, 50%, etc. Reindexing them will make no difference. There is no point reindexing tables unless they have > 1000 pages of data, really.
Showing the output of SHOWCONTIG will help too and http://www.sql-server-performance.com/articles/dba/dt_dbcc_showcontig_p1.aspx and http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx links would hlep you more.