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?
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.