Solved

Which edition of MS SQL 2008 is sufficient for my needs?

Posted on 2008-10-09
5
194 Views
Last Modified: 2012-05-05
I have built a new server with 4GB ram, 2 Xeon E5410 cpu's on a Tyan Tempest I5400XT motherboard with 4 500gb harddrives set in a 0+1 raid format.
Access 2007 database in a solo physician clinic with no more than 10 concurrent users.

I want to take advantage of the two cpu's.

Can the express edition work for me or will I need the workgroup edition?
0
Comment
Question by:reikolayman
[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
  • 2
  • 2
5 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 22682251
I beleive WorkGroup edition will meet your needs.
0
 
LVL 7

Assisted Solution

by:Cedric_D
Cedric_D earned 250 total points
ID: 22682385
0
 

Author Comment

by:reikolayman
ID: 22682494
I thought the workgroup edition would work, but I was confused by the # processors, as the Xeon is a quad core.  I think by 2 they mean two separate processors and in that event it would take advantage of both cpus.  I also noticed that the express is limited in ram and the workgroup (32 bit) was not limited.

Too bad free sure is cheap!
0
 

Author Comment

by:reikolayman
ID: 22682556
Also if I have 7 users and 1 network printer will I need to purchase 7 or 8 cal?
0
 
LVL 7

Expert Comment

by:Cedric_D
ID: 22776913
When you buy SQL product, usually it already contains 5 or 10 CALs, this stated in the price.
There's no CAL necessary for printer, I think.
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

690 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