Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Undo Data Compression/Partition Row Level Locking Expand / Collapse
Author
Message
Posted Friday, September 17, 2010 6:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 1:57 PM
Points: 19, Visits: 127
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.



Post #988641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse