Is there a way to monitor spikes in temp db usage by process ID?   I am
hoping for some kind of code.
Also, would someone have a list or send a link that programmers can follow
to minimize the use of tempDb and its transaction log file.

Two measure values with different level depth.
I have a table which record the disease student number with different
disease in every grade of different gender in a school, like below
Grade, Gender, Disease, [Disease Student number]

What is the difference between dimension and Virtual Dimension which make by
column of table?

I am trying to figure out how to display ranking
information for sales on SQL Server: for example, I want
to display the No.2 and No.3 most sold products in a day
from a Sales Table (product_id, sales, Date). Can anyone

I'm not a database manager,
I have to recover the old database instead of the actual.
I backed up the old one from a tape backup.
Do i have just to rename the existing one and copy the one

I have a time dimention of Year, Month and Date
I want to know the unit sales  of the first date of every month of every
store.
How can I implement the MDX?

Is "Excel 2002/2003 Add-in for SQL Server Analysis
Services" supported under Win XP SP2 ?
When I try to install it I get "The advertised application
will not be installed because it is unsafe.  Contact your

The prestigious Intelligent Enterprise Readers Choice awards for 24
strategic business applications was announced last week. Apparently
Microsoft SQL Server BI seems to swept all the BI readers choice
awards beating longtime industry BI heavy weights like Cognos &

Does anyone know of any good examples of cube construction
for basket analysis, I can't seem to find much of anything
on this particular type of analysis.
Ta

I want to delete "Inactive" rows in a dimension in my DW, but its slow due
to relationships.
First. I want to keep these relationships to insure a excellent data
integrity

My fact table join with a dimension table with a foreign key.
But there some foreign key in the fact table which doesn't exist in the
dimension table.
When I add the dimension in cube, all no match rows will be filtered out

I have an area dimension with three levels: Area, County, and School
I want to aggregate the number of students with different function in
different level, like that in the school level, I want to aggregate student
number with max, in the County and Area level, and I want to ...

I have been playing with the BI Accelerator more than once, but I was
never able to build anything that works, so I'd like to see if anyone
can help me.
I'm having a problem during the data load phase: all other phases were

Hello people,
I want to inspect the code corresponding to the "BI Accelerator - SMA
Application" But I don?t have the password to do this v?a MS Excell. Anyone
of you know how to do that.

I am practicing building cubes with the analysis manager tutorial.  I follow
their instructions exactly.  Starting from the first tutorial.  But I still
get the error "unable to browse dimension "New Dimension".  Provider cannot
be found.  It may not be properly installed."  When ...