The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
147 views

When to rebuild and when to reorganize indexes [duplicate]

I have been trying to gather information about rebuilding and reorganizing indexes. From stackoverflow page (How Often should the indexes be re-build in sql-server DB?) i got this query : SELECT ...
0
votes
0answers
39 views

Measure fragmentation of a single index?

We are measuring the impact of different defrag approaches that we do one index at a time. How do we query to see fragmentation of a single index, by index name (or table + index). This is on SQL ...
0
votes
0answers
31 views

Including INSERT, UPDATE, DELETE when performing vertical framentation

I had a task to perform vertical fragmentation that involves developing Attribute Usage Matrix (AUM) and Attribute Affinity Matrix (AAM) I do know how to construct them, but I am confused over one ...
-3
votes
1answer
34 views

Database fragmentation

How can we find the list of fragmented objects in the database. And how much space we can reclaim by defragmenting those objects.