Reputation: 14605
Can you partition a table in SQL with SQL 2008 or SQL 2008 R2? Do you need enterprise edition to get partitioning? I can't find a definate answer. I did see in this white paper it says "Table partitioning was introduced in SQL Server 2005 Enterprise Edition and enhanced in SQL Server 2008 Enterprise" which to me seems like I need enterprise but all of the articles I find don't mention it as a requirement.
since my management studio doesn't give me any options I have to assume that I DO need enterprise but I wanted to be sure.
Upvotes: 0
Views: 704
Reputation: 32851
This list of 2008 features will answer your question: Features Supported by the Editions of SQL Server 2008 R2
If you scroll down, you will see that table and index partitioning is only available in the DataCenter and Enterprise editions.
Upvotes: 1
Reputation: 4861
This should cleear it up. You do need the enterprise edition:
http://www.microsoft.com/sqlserver/2005/en/us/enterprise-compare-editions.aspx
For 2008 specifically you can click the detailed link at the bottom of this page:
http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx
Upvotes: 4