Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data compression in large tables in MS SQL server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01519376
Message ID:
01519417
Vues:
43
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform