3

The Story: Once a week, we run a special Maintenance Plan that involves re-indexing 2 critical tables that have ~6 Million records between the two of them. We use SQL Server 2005 Standard Edition.

The Issue: During this re-indexing (~15 min operation), we fail to insert data into the tables, and our clients are dataless.

I was told that SQL Server 2008 Enterprise has a "Online Re-Indexing" that is not present in lesser versions of SQL Server that will resolve our problems.

However, I just found the following option in our Maintenance Plan options (SQL 2005 Standard):

SQL 2005 Online Re-Indexing

My Question: Does this perform that same "Online Re-Indexing" that 2008 Enterprise does? What are the repercussions (performance wise) to enabling this option? Was I almost wooed into purchasing a 2008 Enterprise license needlessly?

Improve this question
1
  • The GUI doesn't necessarily know what features you have available in your specific version...
    – JNK
    Commented Jan 23, 2012 at 18:26

1 Answer 1

Reset to default
5

The option is in SSMS but it will not work. SSMS is not Edition smart so to speak, they did not make it smart enough to hide options specific to the Edition you are running.

If you try to use it, I believe it just gives you a message relating to "this is an Enterprise only feature"; or something close to it.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.