I need to choose the edition of SQL Server 2008 R2 for the project, but I don’t know which edition is best suited. A website should have 2M hits / 100K unique users each month. The site database is very compact and takes up 50 MB. Most queries are SELECTs with some complex joins, but not UPDATE / DELETE / INSERT.
I think the web edition should do the job, but I am afraid that it will not be updated or will not be able to handle the load. What would you recommend?
/ , , . , , - .
, 4 - , 50 . RAM-, , .
SQL Server Express? , , , .
, , , 2M, , , , ( , , !).
. - SQL Express , .