Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data compression in large tables in MS SQL server
Message
De
27/07/2011 15:37:37
Naomi Nosonovsky
Wisconsin, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Re: Data compression in large tables in MS SQL server
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01519376
Message ID:
01519377
Vues:
39
>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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform