KcV (1/4/2013)

---

Hi,

I have just shifted my database of sql 2000 to sql 2008 64 bit after running Upgrade adviser.

then i run DBCC DBREINDEX in all tables.

After that when i checked manually then i found that about 80 % tables are well fragmented having 0 logical fragmentation but rest 20 % tables ware having fragmentation of 40 %,50 %,80 %,99 %.

why it is so high ?

after doing manual re-indexing and re-organizing 2 to 5 times , it is not coming to 0 %.

why this is happening ?

pls help.