Solved

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

Posted on 2008-10-09
5
185 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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