Sql express or sql 2008


I wonder if there s a reason to absolutely go for sql server instead os sql express when you have a small environment. Express asks for less resources and  goes upto 10 gb, wright?

Thx for your feedback.
Who is Participating?
Ramesh Babu VavillaConnect With a Mentor Commented:
below are the limitations on SQL Server 2008 Express edition
1 BCP not suppported
2 Database size is 10 GB and Log file size is 4 GB
3 Profiler not installed
4 scheduled Maintenace jobs not available
5 Import/Export option is not avaialable
janhoedtAuthor Commented:
Ok, thanks. But does sql express require less resources then full version, what makes it more performant?
kanalQkoTechnical Support EngineerCommented:
resources should be similar, anyway I`d suggest you to look for ms sql 2012, which was already released (i`m going to beta exam in a while) ;-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.