I discovered that copying data from oracle using "openquery" with linked
server is sevaral time slower that using "dtsexecui" (dts import/export
wzard). I used the same query for both methods. Does anybode has expirience
solving slowly openquery behaviour? My linked server has ...

I have a SQL Server 2000 Enterprise Edition database TestDB1 with 23 tables
that gets populated by replication from a mainframe server. (Inserts,
Updates, Deletes)
Now we have to move the data from TestDB1 to TestDB2 on the same SQL Server

have an SSIS project and I have a package that drops and creates the
database, creates tables, then I have a package that loads the data into the
data warehouse. Now, I got the request in to only load the data and not drop
and create the database every time the package runs due to ...

I am trying to add tracking capabilities to a messaging system we have.
I am struggling with the design, with a scenario which is pretty common I
would think.
We have 2 databases, one is the management database with all the

I'm creating a datawarehouse and I have a question on a date dimension. My
users want to see the date formatted as such yyyy-mm-dd so they can sort on
it. How can something like this be possible? I never did this so I'm new to
the datawarehouse  - cubes - dimension things.

how does ado.net SqlDataReader.GetString() know which encoding to read the
data into a string as? Does sql sever set this at the column data type
level, server wide encoding setting, os encoding?

I have three cubes in AS. How can I have a separate cube which can retrieve
data from these three cubes and then (similar to  join function in T-SQL)
can join the results?
Thanks,

In my project, for each table i used a surrogate key in my dev
envirronement. Now i want to deploy my database and my reports. But i have
few report wich are based on a particular surrogate key, and this key is
different between the dev and the production. What should i do, ...

I experienced a problem wit a SQL Server Datawarehouse I want to report to
the community. I have a table with a unique unclustered index. A SSIS package
fills this table during load time. In this package I use a OleDB Destination
Data Flow item to fill the table, this with the ...

I am new in analysis service. I just installed analysis service in my
personal computer that has a sql server enterprise installed. When I opened
analysis manager and try to open the server in the left pane, I got error
that no register sql server or it is not in the olap ...

I am Mansur currently serching for a job on Ab-initio.
In the recent interview i was asked a Question what is MQ ?
So please let me know what is it.
regards

Looking out for data size estimation, and server size estimation templates.
To start with data size estimation templates will also do.
Any help will be appreciated. The requirement is kind of urgent.
Regards,

Typically, should the analysis services reside in the same server box where
the DW schema reside e.g. star or snowflake schema?

·         We are in process of using new Kimball toolkit book as our guide to create another DM.  Since we only have one data source, we think we need to pull in all the tables into the staging area.  At first we wanted to just pull in minimal data to populate the Dimension/Fact ...