shane.streeting 51351 (7/24/2013)
Hi,At the risk of asking a question that's already been answered, i too am running sql server 2008 Standard Ed v10.0.5500.0
Everything i've read says that online index rebuilds only work in Enterprise Ed.
However, the Rebuild Index Task in Maintenance Plan Tasks gives the option to "keep index online while reindexing".
Is this just there for show until i upgrade to Enterprise Ed? Or does it actually work?
Thank you
It won't work.
In general, if not in Enterprise, I schedule the index rebuilds for slow times on the server and then cross my fingers. If you find that it's just taking too long, or blocking too much, try breaking it down and only doing a few indexes a night or only doing them on the weekends.
For most people, in most situations, fragmentation is not that big a deal, so possibly reduce the amount of defragging if you do (which could lead to longer times when do finally defrag, just saying) or eliminate it where it's not helping you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning