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

Question

[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?

Answer 1

0

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)

answered Sep 06 '11 at 12:42 AM

WilliamD
25.4k ● 16 ● 18 ● 41

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

Sep 06 '11 at 03:21 AM sql server 2005

(comments are locked)

Answer 2

0

I suggest you use Michelle Uffords Index Defrag-scripts http://sqlfool.com/2011/06/index-defrag-script-v4-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)

answered Sep 06 '11 at 03:38 AM

Magnus Ahlkvist
13.7k ● 13 ● 17 ● 30

(comments are locked)

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

Follow this question

Related Questions