As soon as you have more than one index on a table, you're going to start seeing index fragmentation. But, is fragmentation still an issue? So many seem to say that fragmentation no longer matters with SSDs; unfortunately, this is wrong! Fragmentation is NOT only about random IO, it’s about cache, logging, and ultimately performance. Fragmentation is a problem! Come learn about the less discussed effects of fragmentation as well as the best ways to get rid of it! Find out from the developer who – when at Microsoft – wrote the tools for detecting and removing index fragmentation. In this session, Paul will show you how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.

The video is not available to view online.