All Questions
Tagged with maintenance fragmentation
8 questions
2
votes
3
answers
2k
views
Update statistics more often and stop defragmenting indexes
I have several vendor databases that have most (99%) of the tables clustered on GUIDs. Currently we are rebuilding the tables every weekend. Most tables are 80% or more fragmented by this time.
...
- 1,567
4
votes
3
answers
7k
views
ONLINE vs OFFLINE index rebuilds
I am looking for an opinion, which I know is usually frowned upon, so my apologies in advance.
I'm currently in an environment where every instance is SQL Server enterprise edition.
The maintenance ...
- 2,631
0
votes
3
answers
2k
views
index rebuild/reorganize frequency
I am a dba by accident. I am doing index rebuild/reorganize. I would love to use some scripts once I become comfortable doing these tasks. I did go through some of the forum pages regarding this ...
- 163
1
vote
1
answer
73
views
Why did my indexes drop in size?
I've got the following SP which I wrote to calculate the size of all the tables on my database
SELECT
name,dbo.nice(rows) as [rows],
dbo.nice(CAST(total-indexes as DECIMAL)/1024) as [data (...
- 113
5
votes
1
answer
3k
views
Disadvantages of reorganizing all tables nightly
I consider scheduling a SQL Server job that reorganizes all tables nightly. We don't have enterprise, so we cannot rebuild online (this means we need to reorganize). We also don't want to invest too ...
- 7,360
8
votes
2
answers
2k
views
Defragmentation - Rebuilding Indexes SQL Server 2005
I'm researching defragmenting databases and it seems the following SQL statement is what I'm looking for:
ALTER INDEX ALL ON mytablename
REBUILD WITH(ONLINE = ON)
When I pull the info from sys....
- 209
7
votes
4
answers
4k
views
How does SQL Server reduce index fragmentation?
If a user never runs REBUILD or REORGANIZE on their database, does SQL Server still somehow defragment the indexes?
MSDN suggests that if an index is over 30% fragmented, it is recommended to run ...
- 729
4
votes
3
answers
5k
views
SQL Server Index Fragmentation
When should you rebuild an index? vs reorganize?
What index fragmentation value is considered healthy?
Jason