We have swtiched from MySql to SqlServer, but I don't know what version of SqlServer to use in production ... We have a webapplication (C# / ASP.NET)
- SqlServer Express 2008 R2 ?
- SqlServer Web 2008 R2?
The DB limit is no problem. 10GB is more than enough (the largest DB is 400 MB and is used for 5 years now). The thing I'm worried about is the memory limit of the Express edition.
We have Windows Server 2008, 2 GB memory, what is your advise ? Knowing that we have about 100 - 150 databases, all smaller than 500 MB.
Please let me know