A Quick Look At Compression In SQL 2008 SQL2008数据压缩功能之一瞥Denis Gobo原文：http://sqlblog.com/blogs/denis_gobo/archive/2009/04/07/13137.aspx To u......
I have used just the 10 industry groups from the Industry Classification Benchmark, I left out supersectors,sectors and subsectors otherwise we would have a lot more rows per table. I also did not create fake ISIN Code,SEDOL and CUSIP columns since that would have bloated the code in this post. The code will generate 2780650 rows per table, this is a nice size to test with.
Compression is really nice when you get charged $30 per GB for the SAN, so besides performance there is also a cost benefit in storage
通过执行这里的代码你将了解数据压缩如何奏效。我使用的数据和我工作中的数据相类似（但不完全相同， 我使用假的股票行情记录，而且我并非要对这些股票进行投资）。我从行业分类基准选用了10只工业集团股，同时剔除了supersectors, sectors and subsectors表，否则每个表都会有一大笔数据。我也没有为ISINCode，
3/35 首页 上一页 1 2 3 4 5 6 下一页 尾页 |
