?
Solved

Standard Edition vs Business Intelligence

Posted on 2014-08-05
1
Medium Priority
?
139 Views
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 (http://www.targit.com/en) .

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?
0
Comment
Question by:carmodyk
1 Comment
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 40242937
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.
http://msdn.microsoft.com/en-us/library/ms190646.aspx

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"?
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

840 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