Click here to Skip to main content
15,789,776 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
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..


1 solution

Share this answer
venkatgopal.mandada 20-Dec-13 23:35pm    
Thank you.Wht i am seeing above linke is a static partition in the given. i have to create a dynamic partition in sql server based on daterange or any id column...Can you please let me know if u have any idea..
ZurdoDev 21-Dec-13 12:24pm    
I'm not sure what you mean. You need to create separate tables and then use an updateable view.
venkatgopal.mandada 23-Dec-13 1:01am    
Wht I'm asking is how to create a dynamic partition for the given existing table in sql server 2012..Let me know if u have any idea..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900