Skip to main content
Database Administrators

Return to Answer

Formatting
Source Link
Ronaldo
Ronaldo
  • 6.3k
  • 2
  • 14
  • 44

REBUILDREBUILD doesn't do "LOB Compaction". You need

ALTER INDEX PK_ClientHistory ON dbo.ClientHistory REORGANIZE WITH (LOB_COMPACTION = ON)

ALTER INDEX PK_ClientHistory ON dbo.ClientHistory
REORGANIZE WITH (LOB_COMPACTION = ON)

REBUILD doesn't do "LOB Compaction". You need

ALTER INDEX PK_ClientHistory ON dbo.ClientHistory REORGANIZE WITH (LOB_COMPACTION = ON)

REBUILD doesn't do "LOB Compaction". You need

ALTER INDEX PK_ClientHistory ON dbo.ClientHistory
REORGANIZE WITH (LOB_COMPACTION = ON)
Source Link
George Barwood
George Barwood
  • 256
  • 2
  • 5

REBUILD doesn't do "LOB Compaction". You need

ALTER INDEX PK_ClientHistory ON dbo.ClientHistory REORGANIZE WITH (LOB_COMPACTION = ON)