Solved

Sql express or sql 2008

Posted on 2012-04-09
3
161 Views
Last Modified: 2012-04-11
Hi,

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.
J
0
Comment
Question by:janhoedt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
Ramesh Babu Vavilla earned 500 total points
ID: 37826440
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
0
 

Author Comment

by:janhoedt
ID: 37826444
Ok, thanks. But does sql express require less resources then full version, what makes it more performant?
0
 
LVL 5

Expert Comment

by:kanalQko
ID: 37826456
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) ;-)
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question