Pros and Cons of SQL Sever Datamining

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Mining » Pros and Cons of SQL Sever Datamining

Pros and Cons of SQL Sever Datamining

Rate Topic

Display Mode

Topic Options

Author

Message

Mitra_Misra

Posted Friday, February 11, 2011 3:57 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 11:04 PM
Points: 18, Visits: 102

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

Koen Verbeeck

Posted Friday, February 11, 2011 5:05 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 9,364, Visits: 6,462

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

jcrawf02

Posted Friday, March 04, 2011 2:58 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:36 PM
Points: 2,549, Visits: 18,880

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 »

Permissions