Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data compression Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 8:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 30, 2013 1:30 PM
Points: 3, Visits: 61
Hi,

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

Thank you!
Post #1361102
Posted Tuesday, September 18, 2012 8:42 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 23,059, Visits: 31,582
You are going to have be more explicit in your request. I have no idea in what context you are asking about compression.



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
Posted Tuesday, September 18, 2012 8:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 30, 2013 1:30 PM
Points: 3, Visits: 61
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
Posted Tuesday, September 18, 2012 9:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 6,189, Visits: 13,338
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"
Post #1361123
Posted Tuesday, September 18, 2012 9:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:23 AM
Points: 119, Visits: 1,038
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
Posted Wednesday, September 19, 2012 12:11 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:10 AM
Points: 112, Visits: 1,207
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
Post #1361144
Posted Wednesday, September 19, 2012 9:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 10:41 AM
Points: 9, Visits: 192
Thanks so much!
Post #1361433
Posted Wednesday, September 19, 2012 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 10:41 AM
Points: 9, Visits: 192
Thanks for your time!
Post #1361436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse