In SQL Server, are there some points on defragmenting indexes with LOBs? Such as text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml
.
Thanks.
In SQL Server, are there some points on defragmenting indexes with LOBs? Such as text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml
.
Thanks.
Otherwise, nothing special
I'd consider doing a LOB_COMPACTION less frequently but both options comes down to your maintenance windows duration pretty much