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 ««12

Improving Database Design and Performance Using Compression Expand / Collapse
Author
Message
Posted Friday, April 1, 2011 10:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 7:23 AM
Points: 50, Visits: 145
How about using sp_estimate_data_compression_savings, for sql2008 and above.

Borik
Post #1087622
Posted Wednesday, April 13, 2011 1:33 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, October 6, 2014 4:43 PM
Points: 141, Visits: 114
Is it Steven Lugan? Thanks for your comments on the article. I don't have your number. I would be gald to call you or you can reach me at 214-300-8995.


Kindest Regards,

M Suresh Kumar

Post #1093140
Posted Wednesday, June 22, 2011 12:16 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, October 6, 2014 4:43 PM
Points: 141, Visits: 114
Hi Boris,
The system stored procedure, sp_estimate_data_compression_savings for Microsoft SQL Server 2008 has already been mentioned and used in the article to get an estimate of space saving after compression.

----Thanks and Best Regards,
Suresh.



Kindest Regards,

M Suresh Kumar

Post #1129945
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse