Recently I had to brush up my skills on index fragmentation and as a result pulled this query together from a number of useful resources on the net. Just replace ‘DATABASE_NAME’ and run it against the specified database to receive a list of indexes that need attention. Internal Fragmentation is represented by the ‘avg_page_space_used_in_percent’ column… Continue reading Useful SQL Server Index Fragmentation Query