How data compression can be achieved on SQl Databases/tables

Question

How data compression can be achieved on SQl Databases/tables

Mani Dev

Right there with Babe

Points: 717
More actions
September 19, 2012 at 11:13 am

#262703

Can any one provide me with good links where we can achieve Data Compression on Sql Databases/tables.
DO we have any step by step procedure to achieve data compression.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

devullapallymanidhar (9/19/2012)
Can any one provide me with good links where we can achieve Data Compression on Sql Databases/tables.
DO we have any step by step procedure to achieve data compression.

In my opinion nothing beats vendor's documentation, try this http://msdn.microsoft.com/en-us/library/dd894051(v=SQL.100).aspx

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Lowell SSC Guru Points: 323507 More actions · Answer 2

I think compression may be an enterprise only/Developer version only feature.

If you don't have neterprise edition, you won't be able to use it, i think.

there's a really good MS article on the advantages, what to expect, etc:

http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

as for the specific how to compress:

the basic DDL is like this:

CREATE TABLE <table_name>

(<column_names>)

WITH (DATA_COMPRESSION = ROW | PAGE)

ALTER TABLE <table_name>

REBUILD PARTITION = 1

WITH (DATA_COMPRESSION = ROW | PAGE)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mani Dev Right there with Babe Points: 717 More actions · Answer 3

yes your'e right lowel,

Will go through the link you provided me.Let you know if i have doubts.

Steve Jones - SSC Editor SSC Guru Points: 734691 More actions · Answer 4

You might also read this: http://www.sqlservercentral.com/articles/SQL+Server+2008/65292/