1. It's been quite some time since my last index defrag script update. A big part of the reason for that is because I wanted to implement many of the suggestions I've ...

  2. Fragmentation can impact SQL Server performance and space usage. Click to learn about the different types of fragmentation and how defragmentation works.

  3. Once you know how to check index fragmentation, you want to fix it by rebuilding and defragmenting tables. But should you defrag SQL Server 2008 and 2012?

  4. What is Defragmentation? Defragmentation, also known as "defrag" or "defragging" is the process of reorganizing the data stored on the hard drive so that ...

  5. This next script relies on several DMV’s (2005+) that identify missing indexes. While this is good information, the index recommendations do not always make sense ...

  6. Download ApexSQL killer tools for SQL Server DBAs and Developers - 14-day free trial

  7. We have all heard about SQL Server database and index fragmentation, but what is it and is it an issue? Read this tip to learn more about fragmentation.

  8. Is it possible to add a maintenance job to check indexes fragmentation. If greater than 50% then rebuild those indexes automatically ? Index size can vary from 100MB ...

  9. Learn the difference between index 'Rebuild' and 'Reorganize', and how to select which is right for you.

  10. ApexSQL vs Redgate ® comparative articles. This blog post represents an index of pages and articles comparing ApexSQL tools, features, usability, performance, etc ...