Home Forums SQL Server 2008 SQL Server 2008 - General If I compress a primary key, am I compressing the whole table --> P-key with DATA_COMPRESSION RE: If I compress a primary key, am I compressing the whole table --> P-key with DATA_COMPRESSION
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 5, 2013 at 6:45 pm
#1593718
Microsoft. When you create a primary key constraint, if a clustered index does not exist on the table SQL Server defaults the primary key to a clustered index.
Not always what one may want for the clustered index on a table.