I've written a little app, in C# with the 1.1 .Net Framwork, to process
partitions. It can use multiple threads to connect to the same AS2000
database and process the partitions. The work list is divided up between the
thread instances before they are started, so we know they are ...

I've been building out a data warehouse of my product's usage with some
segmentation of our customer base.  I am doing this using SQL Server 2005
Integration Services, Analysis Services and Reporting Services.  My problem
is, I am doing this as a "side project" and I am not  ...

help!! can someone please help me. I built a simple cube with three
tables in. When i clicked on the data tab within the cube editor i can
see my cube data. When i clicked on save the measure data disappear and
just my dimensions stayed there and i could drill down okay but no

I have successfully deployed an Analysis Services Project on Analysis
Server 2005 with SP1. However, when I try to browse the cube using
either BI studio or SQL Server management studio, everything stucks.
Dimensions browsing and cube processing works fine!

I am in the middle of a decision and I would like to ask experts for their
ideas.
I have Sales Reporting System on MSSQL 2000 + AS + RS
So far I have used only USD as reporting currency, now I am going to add

Question from Retail ISV, your guidance appreciated:
Questions:
1.    Is it possible to create a time dimension with these extended levels and
utilize the out-of-the-box functionality provided by SQL Server for time

Is there any exact database size limitation for standard edition? My
database is almost  5 GB and it's getting too slow. Do i have to switch to
enterprise?
Is there any way to check the database to see it's certainly tuned and

Hi, I'm trying to write a MDX query resultset from a cube to a database table
via an SSIS package. I create an OLE DB source in a data flow and choose OLE
DB Provider for Analysis Services 9.0 as the connection manager. Then I run
it through some node afterwards but it's the OLE ...

We were hoping to use fuzzy logic transformation in a non-data warehouse
application where user of one application search for an address match in
another app.  Is it possible to access fuzzy logic functionality through
T-SQL or through an API?

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.

I am using SQL Server 2000. I have created one database named : ICS
This database was working fine just few minutes before one of its table
named "LogInOut" has stoped responding.
Now even if i go for deletion it doesn't respond. Rest of the tables are

A while back, I had the worst 6 month period of my life. It was awful, every
day I would come home from work in a bad mood and stressed. Every day I
would go to work dreading yet another day. Why did my life suck so bad?
Because I was a full time query writer. Every day I would get ...

A while back, I took Microsoft Course 2092A: Designing and Populating a
Data Warehouse with Microsoft SQL Server 2000. I have been reading
about SQL Server 2005 and see that it has several new data warehousing
tools. I want to learn more. Is there a course for building data

I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to connect
to a Progress v9.1C database as datasource. SQL Server 2005 operates on the
.NET platform, I'm not aible to connect to progress from the datasource tab
in the ETL-tool part of SQL Server 2005 (there is no ...

How does one decide if data should go into a fact or dimension table?
I have 1 primary key and lots of textual information (5 fields) which
suggests dimension.
However, the data is extremely unlikely to change, which suggets fact??