Lee Walsh covers index fragmentation, several ways you can identify it, and why a more granular approach to index maintenance can save time and allow you to focus on other tasks during maintenance windows.
Category: Fragmentation
Do you know if the nonclustered indexes in your databases are being used effectively? You may think they are, but do you really know?
Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.
Mike Wood introduces SentryOne's Azure Marketplace.
Melissa Connors continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
Paul Randal of provides some thorough and helpful tips on reducing or eliminating index fragmentation.
Aaron Bertrand shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.
Paul Randal of SQLskills describes several ways clustered index fragmentation can sneak up on...
Erin Stellato of SQLskills.com continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.
Lori Edwards explains an add-in for SQL Sentry Performance Advisor, Fragmentation Manager, aimed at helping you manage and automate index maintenance.
