Menu
What can you do in SQL Server 2008 Standard Edition that you cannot do in SQL Server 2008 Web Edition?
I've seen the Microsoft feature lists, but I am wondering from a very practicle standpoint where I am going to run into limitations.
822
Windows Server 2008/2008 R2 and SQL Server 2008/2008 R2 have both met their end-of-life dates: July 9, 2019 for SQL Server 2008/2008 R2 and January 14, 2020 for Windows Server 2008/2008. If you're still running any of those machines, you're doing so at your own risk—especially in this age of cyberattacks.
The "Function request not supported" error is a SQL Server error that occurs when the SQL Server drivers are missing or the wrong SQL Server drivers are installed on the system. This error occurs when the required drivers for SQL Server are not installed.
You can use MS SQL web if your application runs smoothly capped to the lesser of four sockets or 16 cores and it needs a buffer pool of less than 64 GB for both Columnstore segment cache per instance and memory-optimized data size per database.
SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications.
Have you seen this matrix as well?
http://msdn.microsoft.com/en-us/library/cc645993.aspx
From what I can tell Web excludes a lot of the more advanced features, especially those related to development and data mining, but nothing that would stop you from using it for a non-enterprise web site's data source. It seems to be between the Express version and Standard version.
169
One of the biggest limitations is that it can't be a publisher for SQL replication. If you want to have multiple database and replication data between them, then you need at least one SQL server to be Standard or Enterprise to act as the publisher.
8
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Edit: Sorry, you've probably already looked at the above.
1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
