Hola os cuento.
Tengo un Servidor de dominio con W2000 Server.
He montado otro W2000 Server que no est? como controlador de dominio. Est?
como servidor de aplicaciones. En este servidor necesito entrar con la

I want to store a load of numeric value to 2 decimal
places, i.e. 28.65
I have been reading my SQL server guide, trying to decide
on the best datatype to use, but I have just got more

    I hope someone can clarify this to me.
I have DW Database which is the for a OLAP Database I
created in AS. I have created cube with the necessary fact
tables and the dimensions. my question is whenever the

I want to move 42M rows of data from one OLTP SQL2K DB to a SQL2K data mart.
Would DTS be faster than a straight INSERT statement where the source is in
a different server than the destination?
Additional facts:

I want to build a strcuture like this!!
Dimension Name
                          !_Calculated Parent
                                                       !_Calculated Children

I am trying to handle some code using msmdarch and keep getting an error
exec xp_cmdshell "cd C:\Program Files\Microsoft Analysis
Services\Bin\msmdarch.exe" /a zacwin2k "C:\Program Files\Microsoft Analysis
Services\Data\" "FoodMart 2000" "C:\FoodMart.cab"

I could not get my ASP pages to connect to the Analysis services
Server on a different box.  The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")

I have a Calulated Member that is calculating an average.
[Measures].[Overall Satisfaction]/[Measures].[Count Of Survey]
The problem is that for some of the items there are no surveys, so there are
NULL values in the database for these.

Hi, I'll appreciate your help to solve my develop problem.
I need to use a conditional expresion to assign a calculated member
value to cube members. I can't use the IIF function because I have 3
possible values (eg A,B,C). How can I implement the "ELSE" condition? In

Currently, I'm working on a SQL Server DWH.
I work on a snowflake Schema. Let say that I've on product table wich is
linked using a FK on a product grouping key to a product group label.
If  I update my product refrential, this works but ...

How do you partion a fact table in SQL server, it appears from
the documentation one would have to treat it as a
cube or even have to make a cube out of the fact.
Lets say I a huge table and I would like to partion

If I want to build an architected data warehouse, otherwise known as a star constellation of multiple facts and conformed dimensions, I'm trying to figure out how to separate the physical tables by database.  Think about modeling the constellation in ERwin.  You want to have ...

The "issue", that I have, is that the OLAP server sums every measure regardless the type of dimension. For example, suppose that I have a fact table which loads every Friday the account balance for the customers. And for example the account balance is not additive by time as if I ...

Has anyone any knowledge of optimizing MDX?
I have several MDX queries I have inherited, which take (some) in excess of
a minute to return.
I have been through Spofford's book and others. None seem to address a best

Hi - I've got a dimensional modelling question that's got me stuck.
I have a "Student" entity and a "Student Transaction" entity.  
The Student Transaction table will be a fact table -- that's easy.
And the Student will be a dimension of the Student Transaction table.