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.
Copyright © 2021 Jogjafile Inc.
Otherwise, nothing special
I'd consider doing a LOB_COMPACTION less frequently but both options comes down to your maintenance windows duration pretty much