We have installed two SQL Server instances on the same
machine.  The machine itself is rather high end, with 4GB
of memory and a quad processor running Windows Server
2003.  Each of the two SQL Server instances hosts a rather

I have a small question. Is it possible to create multilingual data
warehouses (cubes). I have to create a Data Warehouse for one of customers
who has data in couple of countries. They need to query the data according
to their culture setting. Atpresent I'm using XMLA for analysis ...

I encountering the following error whenever I try to create a new dimension
in the MS Analysis Server.
"Unable to count the members of the 'Area Code' level.Please check your
table joins."

Hi, I am developing DTS that extract data from Oracle via
Linked server. I'm using MS OLE DB for Oracle.
The following error message prompted when I query to
selected tables (12 tables out of 40+ tables) in Oracle.

i have to implement an olap server inside of different domain.
these domains dont have trusts, and they can't--
i can't figure out the best architecutre here.
Just pretend for a second, that this is my arch.

I am running into a problem where some of our tables are
creating the log files to grow even with simple
recovery.  Everything I read says that simple recovery
will prevent this.  We especially notice this when we

in a datawarehouse with SQL Server 2000,
what are your recommendations for when to reindex; update stats or just
defrag the indexes?
Actually, I update the statistics of the loaded table in my DTS package.

I have done this experiment on one of the tables. There is table called
build havinf nvText Field with large no of records. I want to drop that
column and recover space. These are the results I got.
SP_SPACEUSED ?BUILD? Results

When looking at the SQL online books the Period To Date Function Topic is
disable and would like to see what this function does, cause i am looking in
to calculation the sales figures in SQL using the Period To Date Function
and The Year To Date, but both this functions are disable, ...

Hi,
I am having a problem with my update statement for my
DataMart. (Using example here).
I get text file & load it into  TableA in Staging. From

I'm really frustrated because it appears that Microsoft Data Analyzer's
support/compatibility with "standard" MDX is pathetic :(
I need to calculate the following but just can't figure out the "~Aspect
... " logic which Data Analyzer uses:

I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but

Sorry for the cross post but this is really urgent and I am at the end
of my wits,,please can someone help.
Sorry for the botheration and really many thanks in advance.
Where  are all the gurus :(

Does any one know where I can find examples with T-SQL(or
any other DB language) scripts for buliding & loading
data in the Fact & Dimension Tables. It will be a great
help for me to look at examples.

I am building datamart but I need your expert advise to
update the datamart.
I get text file & load it into Staging Table.  From
Staging Table I load it into Dimension table