There are 7 mining algorithms in sql server 2005. (Decision Trees,
Association Rules . . .)
How many the next version?

While running setup for the Business Scorecard Manager 2005 Beta 2, when
I get to the feature requirements analysis under web parts, I get the
message
"Failed    Microsoft SharePoint Extended Site"

I have created a scorecard and want to map it to the analysis cubes.
The scorecard has 2 Perspectives whose KPIs are to get their values
from 2 different cubes in analysis services.
The problem is when I go to map the scorecard to the views, I can only

I got a number different selections for the same schema and table and I want
to join them on the primary key to see if any row will show up in more then
one selection. Is this possible?
Thanks in advance!

If your IT department were in a position to choose between Crystal
Enterprise 11 and Reporting Services 2005, which platform would you choose
and why?
Also, if you don't mind answering one or more of the following questions

I keep getting this error when i send a large document into sql server with
ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough
storage is available to complete this operation. I have about 8 gigs of
memory on the machine and sql server isnt using even half of ...

I know there is a book on this topic, BUT is a star schema the optimal
data model design for data mining ?  I assume so since 3NF or highly
normalized models are more complex to query..  any thoughts would be
appreciated.

I have create an asp.net(.aspx) page, with a PivotTable control.  I noticed
that, I can't reference it in my code-behind(.aspx.vb), because it doesn't
has the line 'Protected WithEvents PivotTable1 As OWC10.PivotTable' as
creating other controls, liked Label, Button, ...

I am wondering about the availability of the analytic functions LAG and RANK
within SQL Server 2000.  THese are available in Oracle, but I was wondering
about SQL Server.  
Please help

Other than the following character:' are there ay other character that may
cause a problem in SQL Server specifically invisible characters?
Thank you,
Shmuel Shulman

I am trying to make a calculation, which requires me to work out the average
of the lowest 6 numbers of 12 numbers. Can anyone assist me in how to create
the select statement?
Thanks in advance

I've created a view joining (in essence) customers with sales.  I am
then trying to predict sales amount (continuous) by customer attribute
inputs.  I selected DISCRETIZED(EQUAL_AREAS,4) for the predicted
variable (sales amount).

I've created a view joining (in essence) customers with sales.  I am
then trying to predict sales amount (continuous) by customer attribute
inputs.  I selected DISCRETIZED(EQUAL_AREAS,4) for the predicted
variable (sales amount).

shopper_tracking
shopper_id   tracking_num    closed    date_entered
12345          1za45690987    1           8/15/2005
65984          1za45690988    1           8/15/2005

I want to know how to retrieve records from a SELECT command in sections. I
mean, if total records of a SELECT command is 100,000, I want to use SELECT
that retrieves me them in 20 "sections" of 5000 : first 5000, second 5000,
sixth 5000 or the last (20th) 5000 according what ...