the error is "not enough storage is available to complete this operation".I
use
"import/outport data" to import a txt file,the file size is about 111M. The
preview is ok, and a small size txt file is ok too.BTW, i use sql server2000

So which scenario would the join run faster (I'm talking about > 2,000,000
records in each table)
1)ID is PK, F1 & F2 are unique and index
table1                           table2

Being new to OLAP, this will probably be an easy question. I have installed
analysis services and have built a cube and the data looks great in the cube
data browser. Now, how do I get this data to end users. I know I can use
Excel Pivot Reports, but we use Delphi 2005 and am ...

I'm a MDX newbie and trying to define a simple MDX-select statement. Is it
possible to add dimension and level headers on top of the matrix, like in
typical Excel pivot tables?
thanks in advance

       I got the following error when I tried to generate a virtual cube
from an MDT data mining model:
       Error(-2147221425): The object structure is not valid (The
SourceTableFilter of a dimension of subclass type sbclsMining must be of the

Hai,
      I have a Relational table named Candidate.
the fields of that table are
candidateid   name    skills    expinyears

Hai,
       I am using Microsoft Clustering algorithm to group the sales based
upon the location.
I have the olap cube and it is working.

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates

ReportPortal 2.0 now lets you visualize Microsoft Clustering and Decision
Tree mining models for SQL Server 2000.  Please take a look and give me
feedback.
http://www.reportportal.com/Flash/mining.html

I'm pretty new to these terms.Just wondered if there is any difference
between OLAP and Datamining?
Thanls

I have a database table containing time series data,
which are one year's speed measurements for a road section.
The first column is the datetime of the measurment,
and the second column is the speed value. Values were

Is there a book or a website or a magazine where i could find a comparrison
of differente multy strategy data mining software products? And also do You
have any suggestions on which data mining product to use for retailing and
telecommunication industries?

Is this forum an appropreciate forum for me to post questions regarding SQL
2005 Data Mining/Data Warehouse?
If it is NOT, can you give me the link to the correct forum.  I really
appreciate anyone's help.

If i use Case in a query, is there a way to retrieve the top, lets say, 10
for each case within the same query, instead of making different select
statements for each case scenario?
Hence, if i have 3 Cases in the Query, i should have three Top 10's for each

Hi Jamie Maclennan,
            Is there any way to test my decision tree.I have trained my
decision tree using my dataset.Is there any tools for testing the
accuracy of my tree( that is applying test dataset to my tree)and