谁是谁的谁 2011年12月04日
这道题关于行压缩和页压缩
You administer a SQL Server 2008 infrastructure.
You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is frequently queried by several reports. The last partition is heavily queried and frequently modified.
You need to minimize the disk space of the table and ensure that this has minimum effect on the query
performance.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
你管理一个SQL Server2008基础设施。
你在数据库中最大的表分为四个大小相等的分区。前两个分区都很少查询。第三个分区是频繁查询的几份报告。最后一个分区是大量查询,并经常修改。
您需要尽量减少表的磁盘空间,并确保这对查询性能的影响最小。
你应该执行哪两个动作? (每个正确的答案,提出解决方案的一部分,选择两个。)
A. Enable ROW compression for the last partition.
B. Enable ROW compression for the third partition.
C. Enable ROW compression for the first two partitions.
D. Enable PAGE compression for the last partition.
E. Enable PAGE compression for the third partition.
F. Enable PAGE compression for the first two partitions.
标准答案是BF

我想弄清楚的是到底什么情况下用行压缩,什么情况下用页压缩?
...全文
110 点赞 收藏 7
写回复
7 条回复

还没有回复,快来抢沙发~

发动态
发帖子
疑难问题
创建于2007-09-28

9303

社区成员

12.1w+

社区内容

MS-SQL Server 疑难问题
社区公告
暂无公告