Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Pros and Cons of SQL Sever Datamining Expand / Collapse
Posted Friday, February 11, 2011 3:57 AM


Group: General Forum Members
Last Login: Monday, September 30, 2013 1:56 PM
Points: 18, Visits: 103


I need to give a proposal for a project where i need to suggest SQL server data mining. I need some information on the pros and cons of SQL server data mining like how much data it can handle , performance , flexibility , which business scenarios it will not help etc.

Any information on comparison of SQL server data mining with other data mining tools in market like SAS , Clementine , Intelligent Miner etc.
Post #1062448
Posted Friday, February 11, 2011 5:05 AM



Group: General Forum Members
Last Login: Yesterday @ 6:23 AM
Points: 15,499, Visits: 13,162
As I don't really know the other tools I can't really give any cons of SQL Server, aside from the learning curve perhaps.

But I've got some pro's:

* If you have already SQL Server: it is free!
* Good integration with Excel (which is still the most commonly used BI interface)

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1062482
Posted Friday, March 4, 2011 2:58 PM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, January 30, 2015 8:42 AM
Points: 1,332, Visits: 19,324
BOL has some good links to get you started: for 2005, for 2008 and for 2008 R2.

Other alternative to consider is the R Project, free, open-source, widely used in the statistical community. Not sure if there's any direct comparison to SQL Server out there, probably something comparing to SAS

How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1073593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse