question

nishant.nandgaonkar avatar image
nishant.nandgaonkar 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?
sql server 2014sqlserverpartitioning
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Tom Staab avatar image
Tom Staab answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Tom Staab: thank you sir for information, I think I am unable to do partitioning just because of standard edition of SQL SERVER 2014.
1 Like 1 ·
iainrobertson avatar image
iainrobertson answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

H_G_H avatar image
H_G_H answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.