Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Reorganize Index Task RE: Reorganize Index Task

  • June 13, 2010 at 12:21 am

    #1179575

    sudhakara (6/6/2010)

    Bhuvnesh (3/10/2010)

    Rob44 (3/8/2010)

    Let's suppose the command returns 0! What's the next step if the rebuild of the index in the maintenance plan is unsuccessful?

    We can give manual run to ALTER INDEX [PK__EventStage__46AF6B36] ON [Event].[EventStage] REORGANIZE WITH ( LOB_COMPACTION = OFF )

    and see if problem persists or not

    Hi ,

    its working fine while running this on query analyzer. issues coming while running the maintanance plan.

    Karthik Pls update if you found solution.

    Simulated and Fixed: There is a DTS job for creating and dropping the objects in the database everyday at perticular time. This has been found by using the schema change report in sql server 2005 and fixed by changing the job time of the Reorganize index.