Where are you browsing from? If your using Office, then you need the Office Service Packs, as well as the Analysis Services.

If once you process the cube and you...

DB Journal has some excellent tutorials

http://www.databasejournal.com/features/mssql/article.php/1429671

SAS has a good glossary at http://support.sas.com/rnd/warehousing/glossary.html (althought their dw software stinks!) The Data Warehouse Toolkit by Kimball is good reading.

And there are some great tutorials for Analysis...

I to struggled with creating a flexible reporting format for the web. I moved to the datawarehouse model and most users love it. I have an example here http://www.utcodes.org/queryabledata/cube/default.htm ...

I would be concerned about the speed of the app. DVD drives read much slower than hard drives ... - so your app may seem slow. I have had...

I frequently do this as my secondary drive is a SAN. Having the Program files on the same drive is really not an issue. The only issues you need to...

This does seem very odd. I've done many upgrades and sometimes the files size will grow by at most a few hundred megs. Can you look for dups in your...

select case when CustomerType='ENT' then [ENT Ter] & 'Total' else 'Total' end as TerNew, ...

group by (case when CustomerType='ENT' then [ENT Ter] & 'Total' else 'Total' ...

When you process the cubes, what % aggregations are you setting the system to process? The more aggregations you let it build to begin with, the faster your queries as...

Are you using the SQL Agent to schedule the jobs? Is it started successfully? Have you checked the logs for errors? What about the event viewer for NT do you...

You can also do

exec sp_spaceused @updateusage = 'TRUE' to update useage and get the true space in the db.

Then shrink the db to whatever size to recoop the free...

Right now the market is tough. I don't ever hire non-experienced DBA's. Instead I look for people that have at least worked with databases in some fashion - developer, analyst...

If you need to diagram, then create the database to different systems (Oracle, Sybase, SQL Server ...) then ER Studio is probably the way to go. they have a free...

I agree with above. I did this once and found the card was expensive and not lots of fun to troubleshoot. Much better off to buy a $2000 rack server...

I have Warehouses and OLTP dbs on the same production machines. The only time I run into resource issues is reprocessing cubes. I have 3 cubes with 50 or so...