I wonder how can I diagnose where is the bootleneck of my system.
DTS are running very slow as there is CPU usage about 20% and Avg. disk
queue about 100% all the time.
Is this mean that disks are too slow ?

Does the add in for excel work against RS reports?
Does it work against local cube files?

For ETL purposes, I'm wondering whether it would be better to:
- grouping all my heterogenous source systems tables into a same Staging
Database
or

Is there any easy way to create a dictionary or lookup function based on
Dimensions in a cube?  We only have 4 cubes so far but the big one has some
50 dimensions and sometimes finding the attribute you want to report on is
consuming.

I've got another issue in my company's datawarehouse system. SQLAgent
eventually loads CPU with 20 - 25% of activity.
What can be the reason for this?
Thanks

I have an e-commerce database that has both OLTP and Reporting
applications. OLTP applications mostly write and do very little
reading, only few records at a time (POS type of client), but there is
a lot of clients. Reporting applications read large amounts of data,

My problems with SQL Server 2000 SP4 multiplies. Long running queries are
blocking each other (even themselves); i.e.:
SPID:58 blocked by 58 locktype: PAGEIOLATCH_SH
I've discovered a lot of I/O contention due to PAGEIOLATCH_SH lock type. I'm

I want to retrieve Primary key value from my OLAP Cube. can you please tell
me how can i do this in below query?
SELECT NON EMPTY { [Measures].[Total Test Count] } ON COLUMNS,
NON EMPTY { ([Dim Station].[Station Name].[Station Name].&[1ST CHOICE

in sql server 2000 when you issue a alter table to add new column, can you
specifiy the order? meaning i want that column to be between existing
columns, not at the last

ERROR
"Too many columns found in the current row; non-whitespace characters
were found after the last defined column's data."
SOLUTION

Is there any way to import a cube created in AS 2000 into SSAA 2005?  If not
a direct import is there any way to make that job easier?  Any
suggestions/pointer/comments would be helpful.  I have a lot of AS 2000 cubes
and I am really sick of that development environment!

I want to build Dynamic MDX query in SQL Server 2005. Is it possible?
ex. I have one SQL Server Report parameter which contain following value:
1. Station
2. Free Test

I have implemented SQL Server 2005 Developer Version at Windows XP
Home. I'm working on localhost.
I want to do an assoziation analysis and creating data source and data
source view is successful. But when the data mining wizard comes to the

In 2005 there is a new'ish' kind of replication called Mirroring which
is only available in SQL 2005 sp1.  When you create a mirrored database
on another server, the 'Principal Database' stays online, while the
'mirrored database' goes into a constant state of restoring.  My

I am investigating whether there might be some commerical package that
might meet this kind of requirements.
I need a reporting system that will allow users (e.g. programmers for
the users) to write their own reports. However, I need to be able to