Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data compression in large tables in MS SQL server
Message
From
27/07/2011 15:37:37
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Re: Data compression in large tables in MS SQL server
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01519376
Message ID:
01519377
Views:
38
>Hi All,
>
>In MS SQL 2008 and later version the data compression really saves a lot of GB of HD and increases the query performance. Please check this article: http://dfarber.com/computer-consulting-blog/2011/7/26/data-compression-in-large-tables-in-ms-sql-server.aspx and see how much GB I saved on a 44GB table.
>
>
>Regards,
>
>Doron
>http://www.dfarber.com

Nice article. I think I also read a very interesting article on this same topic in Phil Factor (I'll search for this later).

For now few more links on this topic

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/do-you-get-a-benefit-from-compressing-ba

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/compressing-data-with-uniqueidentifier-columns
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform