Does partitioning work with SQL Server 2005 Standard edition SP2

I am using SQL Server 2005 Standard edition with SP2 in test environmen开发者_开发问答t. 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.

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.

24M isn't huge but saying that partitioning wouldn't improve performance is a blanket statement; some cases no, some cases a little and some cases substantial performance increases. If you are using Standard, you can create your own partitioning by splitting the table and throwing a stored proc in front of it (or i guess you could do it in your app code but wouldn't recommend it). Of course things like how you are searching and what the data is would dictate how you split the table. Many will say otherwise but have been in the same boat when hardware limitations and processing power are boundaries and it most definitely makes a difference searching 2M rows vs 24M or 60M rows regardless of how great your indexing strategy is.

We have implemented the indexed views to solve the issue with the performance. It is working great now. Thanks for all the help