SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance | Journey to SQL Authority with Pinal Dave

Just a day ago, while using one index I was not able to get the desired performance from the table where it was applied. I just looked for its fragmentation and found it was heavily fragmented. After I reorganized index it worked perfectly fine. Here is the quick script I wrote to find fragmentation of… Continue Reading...

Source: SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance | Journey to SQL Authority with Pinal Dave