Tag: index fragmentation

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 6 min read

SQL Server DMV Query to Output Index Fragmentation by Database / Table

Learn how to query SQL Server index fragmentation using DMV views and identify which indexes need rebuilding or reorganising to restore query performance.

Read article →

15 May 2018 · 5 min read

How to Check Fragmentation Level of a Database

Index fragmentation builds silently and drags down SQL Server performance over time. Learn how to check fragmentation levels and identify which indexes are worth acting on.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.