Pros and Cons of SQL Sever Datamining

  • Mitra_Misra

    Mr or Mrs. 500

    Points: 566


    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    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)

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • jcrawf02


    Points: 24198

    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[/url], 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[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "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."

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply