As soon as you have more than one index on a table, you’re going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn 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.
Paul Randal is the CEO and co-owner (with his wife, Kimberly Tripp) of SQLskills.com, a world-renowned training and consulting company. He worked on the SQL Server team for 9 years, most notably rewriting DBCC CHECKDB, and since then has been a SQL Server MVP and Microsoft Regional Director. Paul is an accomplished writer and presenter, with numerous books, articles, whitepapers, and conference top-speaker awards over the years. You can read more about Paul at www.SQLskills.com/about/paul-s-rand