Index fragmentation and size
I'm just trialling the SQL Index manager against some SQL Azure databases. After running the analysis I get a number of indexes listed as highly fragmented (98%) and large (3823138 pages). When I run the rebuild script and then analyse again, there is no change.
Did you have any thoughts or recommendation?