luckysql.kinda (12/2/2009)
I want you to go ahead and remove the indexes which are referring LOB (text,ntext,image) and run rebuild again.
Why?
External fragmentation usually refers to file-level fragmentation that's fixed with a disk defragmentation program.
Internal fragmentation usually refers to fragmentation of the index pages that's fixed with ALTER INDEX .. REBUILD or ALTER INDEX ... REORGANIZE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability