Mining Algorithms

I would like to use SQL Server 2005 data mining to look at some engineering problems. In order to really do that, I would like to see some reference material on how the different algorithms work. Does anyone know where I could find some? I have looked hard thru BOL and cant find any there.

Hi!

You can find a lot of useful material about Data mining algorithms on URL: www.sqlserverdatamining.com. And also in SQL server 2005 tutorials for data mining which is a part of SQL server 2005 documentation.

|||As I wrote in another thread, usually I need only online documentation to learn new features of applications, but I found the online materials are inadequate for me to grasp the data mining part of SQL 2005 after spending a lot of time on them. I am half through the book Data Mining with SQL Server 2005 and have found it is quite helpful for learning the concepts and practical steps even though it has lots of editorial errors (fortunately they are so obvious that they do not pose much risk of misleading readers).I (scientist in R&D) am using DM to explore real problems now.|||

Online documents is sufficient enough to understand various features of SQL Server. If you want to learn moreabout mining algorithms to find best suitable for your purpose here is a good site

http://www.kdnuggets.com/

Mining Algorithms

I would like to use SQL Server 2005 data mining to look at some engineering problems. In order to really do that, I would like to see some reference material on how the different algorithms work. Does anyone know where I could find some? I have looked hard thru BOL and cant find any there.

Hi!

You can find a lot of useful material about Data mining algorithms on URL: www.sqlserverdatamining.com. And also in SQL server 2005 tutorials for data mining which is a part of SQL server 2005 documentation.

|||As I wrote in another thread, usually I need only online documentation to learn new features of applications, but I found the online materials are inadequate for me to grasp the data mining part of SQL 2005 after spending a lot of time on them. I am half through the book Data Mining with SQL Server 2005 and have found it is quite helpful for learning the concepts and practical steps even though it has lots of editorial errors (fortunately they are so obvious that they do not pose much risk of misleading readers).I (scientist in R&D) am using DM to explore real problems now.|||

Online documents is sufficient enough to understand various features of SQL Server. If you want to learn moreabout mining algorithms to find best suitable for your purpose here is a good site

http://www.kdnuggets.com/

sql

Migration to Yukon

Hi,

Anyone kindly let me know more and clear details about the below 2 statements

1.Remove reference to undocumented system tables/stored procs

2. Remove statements modifying system objects

as are not supported in SQL Server 2005. while migrating from sql server 2000 to YUkon (sql server 2005) the above 2 points need to be taken care. but no much clarity on the above.

kindly help me

Regards

Crish

Hi,

not sure above the first one, which procedure are deprecated but the latter one had some major chnages. The system objects are now in the sys schema,e.g. changing the sysobjects to sys.objects. if you used INFORMATION_SCHEMA views before you don′t need to change anything, because the views were also modified to reflect the changes, if you use direct access to the system tables, you have to change your code.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Thanks much for the information Jens.