August 5, 2010 at 2:07 am
hi there!
i want to create two maintenance plans wich one of them is doing rebuild for all of my DB's in my instance and the other one is doing reorganize.
now, when i trying to, i have been noticed that it is not that easy as SQL Server 2005-
there is only option to reorganize but not to rebuild.
can anyone help me with this?
August 5, 2010 at 5:40 am
When you are creating the maintenance plan in SQL 2000 Enterprise Manager the "Reorganize data and index pages" option under the Update Data Optimization Information, is a little tricky.
When you finish creating the Maintenance Plan, you will not that a job named "Optimization....". When you run this job, it in fact does DBCC DBREINDEX with specified fill factor.
Please try it on a test server.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 5, 2010 at 5:45 am
so how do i reorganize?
August 5, 2010 at 5:50 am
If you're rebuilding indexes you don't need to reorganise as well.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2010 at 8:26 am
and why is that?
August 5, 2010 at 9:59 am
Reorganise shuffles the index pages into order. Rebuild drops the index and recreates it with the pages in order. Why would you want to do both?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply