Can I run the Rebuild index for compatibility level 80 database in sqlserver 2005?

Question

question

sql server 2005 asked Sep 6, '11

Can I run the Rebuild index for compatibility level 80 database in sqlserver 2005?

Can I run the Rebuild index for compatibility level 80 database in sqlserver 2005? **[Edit - additional information:]** And I got a 60 tables are have heigh fragmentation so can I do the rebuild index and reorganize index by using DMV On compatibility level 80 database in sql server 2005?

sql-server-2005 indexing rebuild dmv

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-09-06T00:42:08Z

WilliamD answered Sep 6, '11

Yes you can. If you have Enterprise Edition, you can even perform this as an online operation (uncomment the second line below if you want to do that). ALTER INDEX [index_name] ON [schema].[table_name] REBUILD --WITH (ONLINE = ON)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sql server 2005 commented · Sep 06, 2011 at 03:21 AM

thanks for your reply.... and go through the question once again please. I added another doute..

0 ·

Answer 2 · 2011-09-06T03:38:27Z

Magnus Ahlkvist answered Sep 6, '11

I suggest you use Michelle Uffords Index Defrag-scripts [ http://sqlfool.com/2011/06/index-defrag-script-v4-1/][1]. I have them scheduled to run weekly for all databases - they check the fragmentation and reorganize when suitable, rebuild when suitable. Regarding the question about DMV and compatibility level 80 - I think you should read this article at SqlSkills: [A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)][2] [1]: http://sqlfool.com/2011/06/index-defrag-script-v4-1/ [2]: http://bit.ly/qSCK1Y

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question