error message
----------------------------------------------------------
----------------------
Server: Msg 544, Level 16, State 1, Line 1

This very important online survey will give you the opportunity to provide feedback on the availability of SQL Server information and peer support in the SQL Server communities.  This will help Microsoft and its community partners to better understand customer needs and how to ...

x-posted to:
microsoft.public.sqlserver.datamining,
microsoft.public.sqlserver.programming
I have a table which is set out something like this:

Hello, I have a table with 200,000,000 records and need
only 20,000 or 6 months of historical data.  Ive created a
temp_tbl and I'm inserting the 6 months worth of data that
I need.  Can I use the truncate command???.  Can I use it

Whenever I opened SQL Server Analysis Manager, it gives me this error:
"DSOInfo: Cannot create temp directory C:\Program FIles\Microsoft Analysis Services\Bin..\metadata\metatemp251\. Please verify that you have enough disk space, and then try again.
How do I avoid this error ...

I am new to MS SQL Server, and saw three choices for Queries.  What exactly
is a Function, a View, and a Stored Procedure?
Matthew

I am very new to using the SQL language and SQL Server
2000 so I am curious about the possiblity of a project I
have been assigned to within my office environment.
I need to create a resume database that would allow for a

SiteNumber    PI    ContactID      Contact   
    ContactTypeText    FaxNumber
===========================================================
=====================

I have two questions:
1. What would you suggest to validate a clustering model
result?, for example can I automatically obtain the
standard deviation or variance from centroid or other

This is the continuation of the post - " Need Suggestions for Data Mining"
First of all, I would like to thank Raman's help. According to Raman's suggestion, AS has the capability to support third-party algorithm providers. Can you give me some websites related to the third-party ...

Hi,
Do you kown what is the maximum quantity of columns that
Analisys Services supports for a Relational, clustering
data mining model?

My company would like to buy a data mining tool. Do all of you have some suggestions to me? I hope that the tool can provide the following functions
1. Cleaning and transformation of dat
2. Can do clustering, decision tree, association, sequence mining, regression (not necessary to ...

I have a sql update statement thats quite large with several "select nests".
It generally takes an hour to run when I need to effect a lot of records.
In VB6 using ADO, I issue the statement and sometimes the update doesn't
actually preform the write (I think when I get over a ...