Hi all I wrote several times to this forum before. And thanks for all the help. My project involves predicting CPU performance by analysis current performance data (through performance counters). I store performance information in SQL database and expect to analyze and predict future performance o...more >>

I am new to Data Mining but I need to develop a tool for mining the apache log file for my final year project. I have several questions to ask. 1. How can I insert apache log file like access_log and referer_log into the sql server 2000, any tools can load all the data immediately? Fo...more >>

Hi All I'm student currently involved in a data mining project. I'm new to MS Analysis servics and need to know how to perform operation in analysis services (creating data mining model, passing data to model from SQL server tables, training, predict etc.) I found out that OLAP and ADO provide thes...more >>

what is the use of DMM_Marginalmodal class? ...more >>

hi evreybody, iam a student fortunately or unfortunately invovled myself on creating a association rule mining algoritham and i am trying to add it to analysis server through the sample provider stuff.on going through the code(excellent code) and spec i got many doubts and if somebody knows ...more >>

I’m very sure the whole data mining process and data warehousing has some good methodology that are being used. Can someone please advice me on the types of methodology being used from the data warehousing process to the data mining stage?...more >>

adv of datamining over sql...more >>

hiye, i'm new to the data mining world, as a student, i need to complete my project somewhere end of this year. Anyway, I've read in many places that in order to acomplise data mining results end of the day, we need to do data warehousing where data are filter and clean. but cani do a data mining ex...more >>

Hi, Is there a way to efficiently monitor SQL performance using SQL Profiler, and my meaning is to see distinct SQL query sent to server (by ignoring parameter values sent with the queries) this mean that query like select * from users where user_id = 10 and select * from users where user...more >>

Hi! is it possible to export the results of a cube from Analysis Manager to an external file? Thanks. JF (newbye) ...more >>

I am a student, I need run "Data Mining Sample Provider Code", I need it now.but I don't have visual parse ++,please help me and giving me vp++ resource code and sn ID to use,or give me its crack,thanks!!...more >>

Hi All I'm developing data mining application in c#. I'm new to SQL Analysis services and dont know how to create a data mining model with c# syntex. I have my database created in SQL. I want to use this database to create the mining model. Is this same as writing a stored procedure? Need help Tha...more >>

This probably isn't the right place to post, but its a starting point. Anybody using the Reporting Services? I am currently using Crystal Reports/ASP and am having difficulties with different versions of ActiveX. Was using JavaViewer, but since MS took their Java out of XP I am forced to look ...more >>

hi guys, m having a problem with the stored procedure copied below. when i try to execute this stored procedure from query analyzer then i get the following error: Error: ---------------------------- Server: Msg 203, Level 16, State 2, Procedure EJ_GetEvents, Line 24 The name 'select sEve...more >>

Hi, How to find Angoss OLE DB for Data Mining Consumer Controls ? Ecir ...more >>

hello I am trying to integrate the third-party data mining algorithms into analysis server,but I can ot known how to do it! please help me and give me enough reference source for me ! ...more >>

I have a company table and I would like to write a query that will return to me any duplicate companies. However, it is a little more complicated then just matching on exact company names. I would like it to give me duplicates where x number of letters at the beginning of the company name match A...more >>

Hello I'm not sure if this question belongs in this category or perhaps in OLAP. So please excuse me if this isn't the right category I often get request for ad hoc reports from our marketing manager. For example, she may want to get an idea of all potential clients in one particular area. I am ...more >>

I gonna to build a CRM system with MS SQL server and I need to use some = data mining technique in the system. but I don't have any experience in = doing this. Can suggest some site or tutorial for me in order to let me = get the ideas on how to built and data mining DB with MS SQL server Mill...more >>

While working through the Analysis Services Tutorial, I do not see the Writeback Advanced Option for the dimension that I am creating. Does anyone know if this is an error in the tutorial, or something that I am doing wrong? I have gone through the steps several times and can not figure out what...more >>

I have a VB6 application that allows the user to provide criteria that is sent into parameters of a SQL stored procedure. The stored procedure selects records based on the criteria, and returns the data to a disconnected recordset in VB. My issue is that some of the recordsets being return...more >>

Hi, I'm about halfway through building a search engine using ASP, SQL and Access. As part of that search engine I need to search multiple keywords across multiple fields So far I've figured out how to split a string into words. From here I could: Construct an SQL statement of varying lengt...more >>

Hi everybody, can anyone suggest me a better sollution to the problem below if any exists? Let's have a table of CARS. Each car can have a lot of properties - electrical windows, automatic transmission, leather, ... almost 50 of them. Each property can contain true/false value. I want to search...more >>

How can I be able to programmatically convert a text (tab delimited) data file into SQL Server? Thank you very much. Joey ...more >>

hi, i have a database with a table that contents about 90 mil. rows (records for over 4 years). Now i have decided that i split up the table in 4 table's. Each table contents one year of rows. So far so good. For a good performance i decided a alter table to put three more fields to the...more >>

Hello all, I was handed a new project and I'm not quite sure how to do it or even what technology to use. Now, I think that SQL Server's Analysis Services could help (or even do the entire thing) but I'm not sure. So, basically, I'm looking for recommendations and ressources on the subjec...more >>

I am in the planning process of upgrading the hardware on our cluster. I need info/advice/suggestions on how to go about this. I am running an active/active cluster on 2 ML370 servers. They are running Windows 2000 Advanced Server/SP2, MSSQL 2000 Enterprise/SP2. I want to know if all I hav...more >>