asked
How to do table partitioning in SQL SERVER 2014 Standard edition?
I am newbie, started learning SQL SERVER from a month.what I know is that,if I use SQL SERVER 2012 or 08 , select a table for partition,right click on it and I can see storage option and partition wizard opens, But I can't see storage option in SQL SERVER 2014 Standard Edition. :( Is there any alternate so that I can do partitioning?
This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
Table/index partitioning is an Enterprise Edition feature in all versions of SQL Server. That said, there are sometimes alternative workarounds that might help if you have standard edition. If you can give us more information about your requirements, we might be able to suggest something.
@Tom Staab: thank you sir for information, I think I am unable to do partitioning just because of standard edition of SQL SERVER 2014.
As Tom correctly says, it's an Enterprise only feature. You can though use partitioned views. Not quite as efficient, as there is a bigger management overhead, but useful nonetheless. Have a look at this:
https://technet.microsoft.com/en-us/library/ms190019%28v=sql.105%29.aspx
Partitioned tables require Enterprise Edition. there are different way to partition in Standard edition you have more than 1 tables and than perform merge operation. Good luck .. H G
18 People are following this question.
