Perry Whittle (1/5/2013)
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.
can you post the fragmentation results please?
I'd still like to see the query that is used to get the fragmentation.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events