February 11, 2011 at 3:57 am
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.
February 11, 2011 at 5:05 am
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 https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2011 at 2:58 pm
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[/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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply