index fragmentation
SQL Server Typical Maintenance Plans: Automatic Statistics Update
Some time ago, we reviewed the automation of index defrag. Now, it is time to look at statistics.
First of all, what do we need...
SQL Server Index Fragmentation In-depth
In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.
SQL Server Typical Maintenance Plans – Part 1: Automated Index Defragmentation
It's incorrect to consider a database as a stable unit, since various kinds of undesirable situations can appear over time — database performance degradation,...
