Search code examples
sql-server-2005database-partitioning

Does partitioning work with SQL Server 2005 Standard edition SP2

I am using SQL Server 2005 Standard edition with SP2 in test environment. My local SQL Server is a Developer edition.

I was able to partition the table on my local computer. I know that the SQL Server Standard edition does not support either indexed views or partitioning. I just wanted to know if the SP2 has made any difference to the Standard edition.

Thanks vihar.

Solution

  • Partitioning doesn't supported in SQL Server 2005 Standard Edition neither it is not supported in Oracle Standard Edition.

    This vendors want you to buy the expensive Enterprise Edition products, which also don't have partitions as default, you need to buy an extra feature which support partitions.

    If your application is written in Jave there is a product called Rewius which might help to solve your solution, as far as I know it works as a proxy above the JdbcDriver and encapsulate the queries and the insert to the database and emulate the partitions feature on Standard Edition database, It is cheaper solution if you only need the partition feature and not other enterprise features.