Is it possible to compress a partitioned index without causing any blocking?
I have 35 partitions that have a clustered index and 2 non-clustered indexes. I would like to compress these partitions, but blocking seems to occur when tried. Is there any way to accomplish this task without blocking? please see my code below
ALTER INDEX PK_indexName
ON dbo.tblName REBUILD PARTITION = ALL
WITH (DATA_COMPRESSION = PAGE ON PARTITIONS (1 TO 35))