Category: Try This

Subscriber bloating when VarDecimal Compressed settings not transferred

Share this PostWhen using compressed “VarDecimal Storage Format Enabled” on Transactional or Merge published tables you’ll discover this setting is not applied to subscribers leading to table bloating. Database Properties Table Properties Try This: Publish table with varDecimal USE [AdventureWorks2017] GO CREATE TABLE [dbo].[DecZero]( [ID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [F1] [decimal](23, 2)
Read More »