No single database (.MDF file) can be over 10 GB.Limited to lesser of 1 physical CPU or 4 cores.
jdbc:sqlserver – Microsoft JDBC Driver for SQL Server ◂ New.MSOLEDBSQL – Microsoft OLE DB Driver for SQL Server ◂ New.MSODBCSQL – Microsoft ODBC Driver for SQL Server ◂ New.PBIRS – Power BI Report Server Versions.SSRS – SQL Server Reporting Services Versions.SSAS – SQL Server Analysis Services Versions.SSMS – SQL Server Management Studio Versions.SQL Server 2008 R2 Compact is a free version of SQL Server for use in embedded environments, such as mobile devices and other Windows systems.Like Standard edition, it has no limitations on the amount of memory used and supports the use of up to four CPUs.
SQL Server 2008 R2 Web is a specialized version of SQL Server for use in web hosting environments.
Microsoft also offers a direct upgrade path to convert Developer servers to production licensing This product has the exact same functionality as Enterprise Edition and only differs in the license.
It can handle up to four CPUs with an unlimited amount of RAM.