question

sql server 2005 avatar image
sql server 2005 asked

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-2005indexingrebuilddmv
10 |1200 characters needed characters left characters exceeded

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

WilliamD avatar image
WilliamD answered
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 comment
10 |1200 characters needed characters left characters exceeded

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

thanks for your reply.... and go through the question once again please. I added another doute..
0 Likes 0 ·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
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 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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