Data compression

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Data compression

Data compression

Rate Topic

Display Mode

Topic Options

Author

Message

gharishreddy12

Posted Tuesday, September 18, 2012 8:39 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 11:39 AM
Points: 3, Visits: 57

Hi,

Can anyone help me find the steps/process for data compression?

Thank you!

Post #1361102

Lynn Pettis

Posted Tuesday, September 18, 2012 8:42 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,588, Visits: 27,375

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1361105

gharishreddy12

Posted Tuesday, September 18, 2012 8:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 19, 2012 11:39 AM
Points: 3, Visits: 57

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!

Post #1361109

Perry Whittle

Posted Tuesday, September 18, 2012 9:43 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:51 AM
Points: 5,201, Visits: 11,146

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" Wink

Post #1361123

DBA328

Posted Tuesday, September 18, 2012 9:49 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:06 AM
Points: 116, Visits: 789

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

[li][/li]

Post #1361124

prettsons

Posted Wednesday, September 19, 2012 12:11 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:17 AM
Points: 99, Visits: 1,023

Tables and indexes can be compressed when they are created by using the CREATE TABLE and CREATE INDEX statements. You should remember that Compression is not available for system tables. There are some consideration points which you have to consider before using page & row compression which you can easily find from here: http://msdn.microsoft.com/en-us/library/cc280449%28v=sql.100%29.aspx

The link also have the examples of Page & Row compression.

SQL Database Recovery Expert Smile

Post #1361144

HarryG24

Posted Wednesday, September 19, 2012 9:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 8:43 AM
Points: 8, Visits: 176

Thanks so much!

Post #1361433

HarryG24

Posted Wednesday, September 19, 2012 9:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 8:43 AM
Points: 8, Visits: 176

Thanks for your time!

Post #1361436

« Prev Topic | Next Topic »

Permissions