如何在sql server 2012上创建动态表分区 [英] How to create a dynamic table partition on sql server 2012

问题描述

我打算根据给定的数据范围为特定的表创建动态分区功能和分区方案。如果有任何人知道，请告诉我。



谢谢

Venkat。

Hi,
I am planning to create a dynamic partition function and partition scheme for a particular table based on given data range.Can you please let me know if any body knows..

Thanks
Venkat.

推荐答案

这是一项复杂的任务。论坛回复是错误的解释地方。网上有很多文章。您需要做的第一件事是了解这种方法的成本和收益，并考虑它是否适合您正在做的事情。第二是确保正确选择分区。实际上，这些是你可能想要在这里讨论的东西，与阅读文章一起，如果你无法理解你所读的内容，那就问一些具体的问题。

This is a complex task. A forum reply is the wrong place to explain it. There's a ton of articles online. The first thing you need to do is to understand the costs and benefits of this approach, and to consider if it's appropriate for what you're doing. The second is to make sure your partition is chosen correctly. Really, those are the sort of things you may want to discuss here, in tandem with reading articles, and asking SPECIFIC questions if you can't understand what you read.

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