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