If we enable Table Data Compression to PAGE level and set Partition Row level locking, I am wondering if the two settings can be undone.
If so, I was wondering if there are any consequences or things to keep in mind.
For eg.,
ALTER TABLE T1 SET LOCK_ESCALATION = AUTO
go
ALTER TABLE T1 REBUILD WITH (DATA_COMPRESSION = PAGE);
GO
Thank you.