The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
507 views

Model for Distributed Database [closed]

I want to design a model for a distributed database solution. Are there appropriate tools and approaches? How to include stereotypes for (horizontal) fragments?
0
votes
1answer
175 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
41 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
32 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
39 views

Database fragmentation [on hold]

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