I want to have your feedback on how to configure my drives to insure a good
performance during loading process & transformation against a staging
database.
Image you have 4 drives available for the staging database & tempdb

I am having a problem with bulk insert when the data in the input file
contains a decimal point. I have given a shortened example below, in reality
the table has about 500 columns and about 5,000,000 records were inserted
sucessfully before records with decimal points were ...

I have a fact table which holds historical records. This table is increasing
exponentially in size. To date there're already over 10 million records. I'm
having trouble maintain this table on updates and queries.
Can anyone recommend any way to deal with this?

       We have two star schemas built into our warehouse: one called
vehicle data and one called parts data. For some reason the warehouse
was built with these quite separate 'data marts' (not sure if that's
the right term)? Even though the parts will always relate to the

I’m looking for some help with analysis services.
I ahve a very simple fact table which has 2 columns
Account Number and Investment Objective.
Fact table

I'm using MS SQL Server 2000 with Analysis Services and have already created
some cubes with mathematical functions for numerical values. The Problem is,
that I also have to represent some text values in my application, and for
having a similar interface I would like to create a ...

  I've installed ADOMD.NET and I've tried to connect Analysis Service with
ASP.NET (using VB.NET). I receive errors but I don't know how I must use
ADOMD.NET. Can somebody help me and show me how I begin?
Thanks.

I found the network transfert rate low between my 2 servers during cube
processes.
I have a 2Gbps network and only 2% is used during loading while I can go up
to 25% during "simple" file copy.

Recently I detached database from SQL Server 2000 Enterprise Manager. When I
try to attach it, I got a message: Error 9003: The LSN (8855:5583:1) passed
to log scan in database 'contacts' is invalid. I have SQL Server 2000 with
SP3 installed. All MDF and LDF files are present. ...

Good day everyone
I have two SQL tables. One is a "Data" table in it with the days in the
dd/mm/yyy format.
Another "Time" table has the

I have 5 cubes. All use shared dimensions in the same Analysis Services
database. In a DTS package, I first fully rebuild the dimensions and the
structure, and, no dimension has the changing dimension property.
After all the dimensions are fully reprocessed, I fully reprocess each ...

My previous post drew no responses so I thought I would restate the problem.
There is OTP data for which an overall OLAP %value is required.
i.e. number of say bad eggs over total number of eggs gives performance of
farm.

Where can I find some real examples or some articles/links of real time BI
with SQL 2K ?

Please help me with the following scenario:
I want to implement an application using eMbedded Visual C++ 3.0 (and then
4.0) to capture data locally on my Windows CE device by SQL (so, I would
like to have an .sdf file on my device where I write data.) This data would