Hi Gail,

There are quite a few examples but I will stick to one or two. The others are very similar, and / or only average 1 fragment per page.

Stats from the DMV

EXAMPLE

Table Data Size .516 MB

Index Space .719 MB

Table record count : 7012

# of Pages : 14

# of Fragments 8

Avg Frag 50%

EXAMPLE

Table Data Size .039 MB

Index Space .016 MB

Table record count : 568

# of Pages : 5

# of Fragments 5

Avg Frag 80%