Home Forums SQL Server 2005 Administering BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005 RE: BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005

  • I've run into this problem too. The only thing that comes to mind is that tables with LOB data types could be the problem. I know that for index REBUILD you cannot specify ONLINE = ON if the index contains LOB columns, but I haven't seen anything stating the same for REORGANIZE.

    Anyone know anything about this?

    In SQL there are no absolutes, it always depends...