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

Min Function Problem

<%
sql="select MIN(psprice)as askBA from transactions where namecompany='BA'and act='Limit sell order'"
set AskBA=server.createobject("adodb.recordset")
AskBA.open sql,conn,1,3%>
<td height="22" width="41"><div align="center">
<% if not AskBA.eof then
response.write AskBA("askBA")
else
response.write "-"
end if
AskBA.close%>

When there is Data which namecompany=BA and act=Limit sell order in table transactions , it's OK. It shows the minimun price.

But the problem is that when there is no Data which namecompany=BA and act=Limit sell order in table transactions, it should show - But it does not show anything.
I don't know why it does not go to condition Else.The query has returned a row, with NULL for askBA. So EOF is not true, instead you need to test the value of askBA.

Migration of Sql Server 7

Hi All,
Greetings,

We have
sql server 7
Sqlserver ServicePack SP3
Sort Order = 32
BuildNumber 7.00.961

on Windows NT,Now we are planning to upgrade operating system from win NT machine to windows 2000.
Please let me know what and all precausion do i need to take what and what all backup should be done apart from user database.
How do i take care of the users,logins,roles, DTS Job and Replication.

Please help me in this and also any links if u have on this topic

Waiting for reply
TIA
AdilWill you also be upgrading to SQL 2000 ?

When I moved to a new machine, we shut down SQL Server on both boxes, copied the database files to the new server and then started SQL Server. Because you are moving master you get all the login id's, etc. Just make sure you are running the same version of SQL server, otherwise it can get complicated.|||yes we are running the same version of SQL server.
pls suggest how do i go about it.

Thanks for ur reply

TIA
Adil