Standard Edition vs Business Intelligence

Posted on 2014-08-05
Last Modified: 2014-08-20
Hello Experts,

I'm trying to find out if a vendor is pulling a fast one or not.   We are going to start doing some "cube" reporting with this 3rd party vendor and they are pushing us to buy the Business Intelligence edition and not the Standard one.  

We are a two hundred employee company, manufacturing and agriculture as our primary functions,  Our database is about 50GB.   The 3rd Party is Targit ( .

The biggest advantage they are stating is that there's a savings of 10 to 15 minutes on Parallel processing on cubes.

What do you think?
Question by:carmodyk
    1 Comment
    LVL 47

    Accepted Solution

    There are definite differences between SQL Server editions, products I work with require Enterprise edition and we won't support them unless on that edition. (Fundamentally this stance is about performance.)

    Here's a table of edition differences as an example, you can see quite a number of features in the BI edition not in standard edition.

    I'm not familiar with the BI edition, or that specific speed benefit, but I would have no reason to doubt such a benefit exists, although its healthy to be skeptical.  Do they have a white paper or something similar regarding the claimed benefit? Have you asked for "proof"?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now