如何在sql server 2012上创建表分区.. [英] How to create a table partitions on sql server 2012..

问题描述

大家好，

我有一个巨大的表，它包含数百万条记录，每天都会发生一些插入。我必须保持六个月的数据，这意味着我的桌子非常大，这就是为什么我在思考table是不同文件组的分区，但我不知道。可以让我知道..





谢谢

Venkat ..

Hi ALL,
I have a huge table it contains millions of records for daily some insertions is occured.I have to maintain six months of data it means my table is very big that's why am thinking table is partition on different filegroup but i have no idea.Can you please let me know..


Thanks
Venkat..

推荐答案

网上有很多样本。我建议阅读 http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c074d8ad-442c-49d0-a5f6-4d9971bceece/table-partition-in-sql-server-2008?forum = sqldatawarehousing [ ^ ]

There are many samples online. I would suggest reading through http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c074d8ad-442c-49d0-a5f6-4d9971bceece/table-partition-in-sql-server-2008?forum=sqldatawarehousing[^]

这篇关于如何在sql server 2012上创建表分区..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！