1
vote
1answer
319 views

Rebuilt nonclustered indexes quickly get fragmented again

I've got a couple of nonclustered indexes on tables that have rows inserted quite often. These indexes are currently around 90% fragmented, according to SQL Server. If I rebuild them, they go down to ...
1
vote
3answers
403 views

Rebuilding the Management Studio Index in SQL Server 2005

Does anyone know if using the SQL Server Management Studio Index Rebuild, rebuilds the index online or offline? Reading the help documentation doesn't say anything on this (so I would assume it is ...
1
vote
1answer
278 views

Index fragmentation and reorganizing database pages

Say you have a database with heavy index fragmentation. Say this database also has a lot of free space due to frequent deletes in its data file. This free space is not contiguous. If I rebuild all ...