Which version of SQL server to choose for Production?
We have a hosting server and we're moving our app to production. Hosting server has
SQL Server 2008 (Web) as our sql server. Not sure if we should have that as production server. I think we need SQL Server 2008R2 Enterprise...not even Standard edition because of it's RAM limitation (does standard has 4GB RAM limitation?).
We dont need SSIS but I do need filestream and database encryption.
Should we ask for Standard or Enterprise SQL 2008R2?