Why use sql server express?

Many times I have found people asking questions like “why to use sql express?”

Today we will discuss about some points why to use sql express.

·         First of all SQl express is free product of Microsoft

·         When it is not required to use all features of sql server we can use sql express

·         Sql express supports maximum size of 4GB (sql server 2008 and earlier) and 10 GB (sql server 2008R2) per database excluding the log files

·         The tool should be used for small to medium scale applications

·         This edition supports many of the more advanced features available in the full SQL Server version, such as stored procedures, views, functions, CLR integration, snapshot isolation, and XML support

·         There is no problem for concurrent users to access and update data at the same time

Hardware-utilization limits:

• Single physical CPU, but multiple cores allowable
• 1 GB of RAM (runs on a system with any RAM amount, but uses only at most 1 GB)