Sql server 2005 enterprise edition comparison

Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. I think it is good now for comparing both function and its features. Is anyone can advise me? If I would like a good book , would you please give me some idea? Thank you for advanced : Kakinang Saturday, January 10, PM.

Top 10 Features for Database Administration. Top 10 Features for Development. Top 10 Features for Business Intelligence. Thank you for your help. Hi, Developer Edition will contain all the Enterprise Edition features, just not licensed for prod.

So, yes, it will contain the works. Good question on Personal Edition. I haven't heard anything on it yet myself but will ask! I use it a lot as well. Reporting Services will be in Standard and Enterprise and Dev. It's not as feature-rich in Standard though as you can see in the matrix. Guss Davey. I am surprised and dissapointed that Table Partitioning is not in the Standard Edition. I wonder if there is any chance that Microsoft might reconsider that one? You must be logged in to reply to this topic.

Login to reply. February 26, at am February 28, at am Gregory A. Larsen, MVP. Greg, I believe the Developer Edition will have all of the features of the Enterprise Edition, but with the development only licensing restrictions, as per SQL Server February 28, at pm There is not easy alternative to this.

There are ways to use the Windows scheduler but You should never remove functionality from a product that is already established well in the field. The result will be that MSDE will still be used for several years, even for new customers. This edition has no limit on the number of processors or amount of memory or database size. It includes all the performance, scalability, high-availability, security, manageability, programmability, integration and interoperability, and business intelligence features, making it a comprehensive data and analysis platform for large, mission-critical business applications.

Standard Edition This edition is a complete data and analysis platform, and it is designed for medium-sized businesses. It places no limit on the amount of memory or the database size, but the number of processors is limited to four. Standard Edition includes high-availability features such as database mirroring and failover clustering, but it does not support online indexing or online page or file restores.

Some of the business intelligence features, such as proactive caching and text mining, are turned off in Standard Edition. Standard Edition does not support partitioning or parallel index operations. Workgroup Edition is an affordable, easy-to-use, and simple-to-manage database solution designed specifically for small to medium-sized organizations.