Confused about paid version of SQL Server 2008

Posted on 2011-10-12
Last Modified: 2012-05-12
I am using the Free version of SQL Server 2008 on a stand alone Windows 7 machine.

I would like to upgrade to the paid version for better performance and I'm having a hard time figuring out what I should buy.  On the Microsoft site it looks like I need to pay $7000, but then I look on Amazon and they have versions for $500.

Can someone point me in the right direction?
Question by:hrolsons
    LVL 69

    Expert Comment

    by:Éric Moreau
    I doubt you will get better performance. What makes you think that?

    Author Comment

    I assumed it would be faster because it can use more than 1 processor and more than 1gb of RAM.  Also, I'm approaching the 9gb database limit.
    LVL 1

    Accepted Solution

    The free version of SQL-server (SQL Server Express) have some limitations with maximum database size and how much RAM it can utilize. So how much performace-gain you will get depends on your database.

    That being said, the prices vary because they are licensed differently. You can license SQL-server per-user or per-processor. If you choose a per-user license you will need to get user-cals in addition to the SQL-server license. But there are also many SQL editions. You have SQL Workgroup Edition, SQL Web Edition, SQL Standard Edition, SQL Datacenter Edition. These differs also in price, but also in features.

    So what to do? First select what edition you need; like emoreau is saying, will you truly gain performance? And what features do you need? Look at a comparion chart from Microsoft:

    Second find out what licensing you need? Are there few users using the data? Choose per-user, are there many or random number of users, choose per-processor.

    Third look in your wallet:-)

    The 7000$ Verions is probably a per processor licensed SQL standard product, and the 500$ version is probably a user-licensed workgroup edition.


    Author Comment

    Only 1 user and all I want is to use more RAM and have no size limitation.

    So I guess I need to look for a single-user workgroup license.
    LVL 10

    Expert Comment

    microsft charges per processor neck.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now