Hello Naomi,

Thanks for your feedback.

Regards,

Doron
http://www.dfarber.com
Check my blog at: http://dfarber.com/computer-consulting-blog.aspx

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