June 12, 2013 at 3:54 am
Hi,
I have a table of 600 million data. This table will grow monthly. We do monthly data load to this table.
Column which i will use is LoadMonth. this will have the value like '201301','201304','201305'
I would like to do a partitioning in this table.
Please help me on this, what are the approaches/steps to create the partition.
Regards,
Karthik.
Regards,
Karthik.
SQL Developer.
June 12, 2013 at 7:10 am
Karthiart (6/12/2013)
what are the approaches/steps to create the partition.
Books Online has good guidance for creating a partitioned table:
http://msdn.microsoft.com/en-us/library/ms188730(v=sql.105).aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2013 at 7:19 am
Karthiart (6/12/2013)
Please help me on this, what are the approaches/steps to create the partition.
Building up on previous post, there is a very nice paper published on SQLServerCentral too, please check http://www.sqlservercentral.com/articles/partition/64740/
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply