Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data compression in large tables in MS SQL server
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01519376
Message ID:
01519417
Views:
42
Found that article I meant

http://www.simple-talk.com/sql/sql-tools/brads-sure-guide-to-sql-storage-compress/?utm_source=simpletalk&utm_medium=email-main&utm_content=BradGuideStorCom-20101214&utm_campaign=SQL

>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
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform