dsachu (2/18/2013)
So, would request you please suggest me why sql is not fragment as per my understanding........because I have read some article.
Because the table's far too small for you to care about fragmentation much. The index in question is a single page.
ObjectID : 515532920
IndexID : 2
PercentFragment : 0
TotalFrags : 1
PagesPerFrag : 1
NumPages : 1
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