Dustin Davis
Dustin Davis

Reputation: 14605

SQL 2008 table partition

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

Answers (3)

DOK
DOK

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

Russell McClure
Russell McClure

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

Related Questions