Data compression

Question

Data compression

gharishreddy12

Grasshopper

Points: 13
More actions
September 18, 2012 at 8:39 pm

#262698

Hi,
Can anyone help me find the steps/process for data compression?
Thank you!

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

You are going to have be more explicit in your request. I have no idea in what context you are asking about compression.

gharishreddy12 Grasshopper Points: 13 More actions · Answer 2

Hi,

Thanks for your reply.

We have few tables in a database which are updated on a regular basis. So, i was asked to do row compression and page compression on these tables. I was wondering if there is any good article/document which can help me in this process.

Thank you!

Perry Whittle SSC Guru Points: 233821 More actions · Answer 3

Have you checked Books Online??

Before just going and enabling compression check the pre reqs and restrictions as there is an overhead and sometimes a performance impact.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

DBA328 Hall of Fame Points: 3952 More actions · Answer 4

You need to know workload characteristics when deciding which tables to compress, please could read following article.It provides some guidelines to assist in deciding what to compress.

Data Compression: Strategy, Capacity Planning and Best Practices:http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

HarryG24 Old Hand Points: 339 More actions · Answer 5

HarryG24

Old Hand

Points: 339

September 19, 2012 at 9:26 am

#1539631

Thanks so much!

HarryG24 Old Hand Points: 339 More actions · Answer 6

HarryG24

Old Hand

Points: 339

September 19, 2012 at 9:28 am

#1539634

Thanks for your time!