本文介绍了Denali中没有表级存储压缩?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我以为我听说Denali会支持新的表级压缩(跨页),但我没有看到任何相关内容。 我们在SQL 2008中通过页面级压缩减少了约50%,将TB减少到500gb,但我希望与表级别相比,
的winzip级别比率为80-90%。

I thought I had heard that Denali would support a new table-level compression (across pages), but I don't see anything about it.  We get about 50% reduction with page-level compression in SQL 2008, reducing a terabyte to 500gb, but I would expect a more winzip-level ratio of 80-90% with table-level.

Denali还有机会发生这种情况吗?

Any chance of that still happening for Denali?

我知道列存储功能,这可能是一种额外的或替代的方法,但显然(!?)除了你的关系商店之外,这只是一个分析立方体,只是你的关系商店。

I know about the columnstore feature, which might be an additional or alternative approach, but apparently (!?) that is only in addition to your relational store, just as analysis cubes are only in addition to your relational store.

谢谢。

Josh

 

推荐答案


这篇关于Denali中没有表级存储压缩?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-28 22:03