Data compression in large tables in MS SQL server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Data compression in large tables in MS SQL server

Message

27/07/2011 15:23:58

Tous

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Maintenance bases de données

Titre:

Data compression in large tables in MS SQL server

Versions des environnements

SQL Server:

SQL Server 2008

Divers

Thread ID:

01519376

Message ID:

01519376

Vues:

J'aime (1)

Naomi Nosonovsky

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