Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Hi,

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:29 AM
Points: 13,741, Visits: 10,716
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 LessThanDot.

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:43 AM
Points: 2,681, Visits: 19,274
BOL has some good links to get you started:
http://msdn.microsoft.com/en-us/library/ms345131(SQL.90).aspx for 2005, http://msdn.microsoft.com/en-us/library/bb510516(v=SQL.100).aspx for 2008 and
http://msdn.microsoft.com/en-us/library/bb510516.aspx 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