Posted by Deepak Kumar | Posted in SQL DBA | Posted on 03-04-2014
SQL 2014 Express edition is free and great head start for small applications or learning purposes. SQL 2014 express is available in 5 variants for more flexibility; its self explanatory names are given below. Each has nearly similar features and limitations except followings. Check the references for detailed list.
- Express with Advanced Services (SQLEXPRADV) with features like :Reporting Services feature, Full-text and semantic search, Specification of language in query
- SQL Server Management Studio Express (SQLManagementStudio)
- Express with Tools (SQLEXPRWT)
- Express (SQLEXPR)
- LocalDB (SqlLocalDB) a very light weighted edition for development purposes.
before considering SQL 2014 express edition installation, you may want to check limitations:-
- Database Engine, and Analysis Services: Limited to lesser of 1 Socket or 4 cores
- Max Memory per instance: 1 GB
- Max Database size: 10GB (data file size only)
- Max instance per server: 50