Undo Data Compression/Partition Row Level Locking

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Undo Data Compression/Partition Row Level...

Undo Data Compression/Partition Row Level Locking

Rate Topic

Display Mode

Topic Options

Author

Message

jeelanik

Posted Friday, September 17, 2010 6:05 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 31, 2013 11:02 AM
Points: 19, Visits: 94

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 »

Permissions