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

  • June 6, 2010 at 4:20 am

    #1176829

    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.