Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server data mining > july 2003

How to know a database is available for connection
Posted by John Xu at 7/31/2003 1:38:37 PM
I want to check if a database server is listening for connection before to connect to this database server. I heard that Weblogic comes with a class called java.util.dbping which does this. However, I am not sure whether other lagnuages have a similar one. To make it short, I am looking fo...more >>


How can I understand that there is an online backup now?
Posted by Fatih. at 7/31/2003 6:30:05 AM
Hi. I was searching which table in msdb database holds the information of "backup session started" or is this data written to somewhere? Thanks in advance....more >>

How to use data mining tools in SQL Server 2000?
Posted by Kyle at 7/29/2003 9:20:42 PM
I know there are some data mining tools which can be used in SQL Server 2000, but I don't know what they are? Could any one tell me what the tools are and how to use them in SQL Server 2000, eg. how to install, anything I must notice in configeration and so on. Thanks a lot. ...more >>

couldn't get the list of data mining algorithms
Posted by P.W. at 7/28/2003 6:03:31 PM
Hi, I am trying to perform some data mining tasks on SQL server 2000. I installed the Analysis Manager and registered server. Then, I created a new database and created the data source. After that, I launched the Mining Model Wizard, selected the Relation Database and saw the tables tha...more >>

Someone can tell me the outlook of Datamining now?
Posted by Kyle at 7/27/2003 8:42:06 PM
I am a freshman to data mining. Could anyone tell me the outlook of dataming now? I want to know the application of data mining and I want to know whether there are tools, including any demo software or any api , can help me study data mining? Are there any websites have the latest ...more >>

simple query
Posted by Al G. at 7/24/2003 10:51:02 AM
I am trying to write a SQL Statement that will return a recordset of the last updated records for a given status. Can anyone help? For example in the data below I want to return the latest open statuses and should get 2 records: Order 1 Open 1/5/03 and Order 2 Open 2/4/03. Order Status...more >>

Datasets for clustering & classification
Posted by John Sandiford at 7/24/2003 2:28:53 AM
Hi, I am trying to find datasets for Data Mining, with a mixture of continuous and discrete attributes, which have well known clustering or classification results. I am aware of the UCI repository, but would really appreciate any information on others. Thanks for any help John Sandifo...more >>

SQL Sum Query
Posted by Peter Newman at 7/17/2003 4:32:24 AM
I am trying to do a complicated count query and need some assistance Table 1 contains a the nomanal codes and discriptions of our account types ( approx 40 records ) Table 2 contains all the transactions recieved from our customers. select * from Table1 a, Table2 b where (b.ACCY...more >>



Data mining model for Finding products sold togeter
Posted by John Jayaseelan at 7/7/2003 7:10:30 AM
Hi, Sales transaction containing columns(product,month & year of sales,sale price) are available. Please tell how to identify the products sold together. How the minning model needs to built using which algorthim? Thanks John Jayaseealn *** Sent via Developersdex http://www.developersdex...more >>

Query ntext fields
Posted by Charles at 7/4/2003 6:45:40 AM
Hi there, I=B4m trying to export a "ntext" field in which I have=20 stored notes (a lot of text). I'm using the Query=20 Analizer, but the select command only returns the first=20 line of the text in each field. It seems that when an=20 enter is found it just finishes displaying the text of=2...more >>

sequence number in a view
Posted by Max at 7/3/2003 9:10:44 AM
Hi folks, I' like to display a sequence number in a view, something like: Name SeqNo ==== ===== John 10 Peter 20 Mary 30 Does anyone know how to generate a sequence number? Best Regards, Max. ...more >>

error in DTS mining analysis task
Posted by Ken England at 7/3/2003 12:18:18 AM
Hi, I'm trying to process a relational data mining model in the DTS Analysis Processing Task. I have already created and trained the model using the Analysis Manager interface with no problems. However, when I try and execute the DTS task I get: Invalid rectangle. Cannot save object i...more >>

How can I use ASP to represent the DM results of analysis services.
Posted by WebDB at 7/2/2003 6:42:19 PM
hi, everyone, I want to use ASP to represent the results of decision tree, etc. How can I do it? Thanks. ...more >>

Table design
Posted by Shamim at 7/2/2003 11:24:35 AM
SQL 2K I am creating a table for holding data used for data wear-housing project. This table will eventually going to have millions of records. Planned to have a primary key and proper indexing in this table. This table will be queried against various columns and will be refreshed (fill data)...more >>

Accessing the List of Olap databases from Analysis server
Posted by John Jayaseelan at 7/2/2003 10:26:22 AM
Hi, The following (VB.NET) code is used to access the list of Olap databases from Analysis server. It only select one database, even that is not the first database in the Analysis server. Please tell why and what change in the code required. ______________ DC1 = New ADODB.Connectio...more >>


DevelopmentNow Blog