I have a problem in one of my production server:
the rows number is exactly 2 billion records and when you do delete, insert,
that row number was not changed( use sp_spaceused to get the row number)
when you do the DBCC check, you got 0 rows in xxxxxxx pages.

I'm looking for samples models for an HR model and specially the employee
dimension table.
What is better a slow changing dimension (with full history in the
dimension)?

I have Question.. If possible install the olap server with winXP to
make cubes in my computer non in the server to practices? if is yes,
what am I Must to do?
thanks

I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is ...

I'm still new to datawarehousing and right now I'm stuck on ETL. So can
anybody give me some links to a good online resurces about ETL technics.
Thanks,
Marius

The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu.  The PC is
very very slow.  What can I do?  I have SP4 for Analysis Services installed.
I thought SP4 could correct the problem but it did not.
When I looked at the Analysis Services in MMC, the PC icon had a small ...

I got a generic DW question.
Let me preface this
I need to design a report that displays data for 3 branches of same
companies, Branch A ,Branch B and Branch C. The problem is that each Branch

I have some issues with a server which is connected to a slow SAN.
the iometer utility says:
SAN= 260io/sec - 8mb/s (32kb block read/write)
Local C:=500io/sec - 15mb/s (32kb block read/write)

We have an application that access multiple databases for generating reports
and running various queries. These databases are segregated as follows:
Server1 DB1 1999-2001
Server2 DB2 2002-2004

Hi all, hope I am in the right newsgroup!
I was looking for insight into a data warehouse design decision.
We are going to have multiple sql2000 production servers (Px) and multiple
sql2000 reporting servers (Rx) each paired at a remote location on their own

I have a DTS package where I load 1.5 millions of rows in a staging table,
and I perform multiple updates.
1 of these updates update the entire table by doing a simple lookup in a
small table.

I have read the SQL 2005 features comparison and I have some questions:
(http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx)
* what is "Star Query Optimization "?
* what is "Data warehousing"??? its a concept, not a technology, so what is this feature?

I have been arguing with my partner if we shoud or not design a normalized
data base or denormalized. How, can we know when we should choose one or the
other?
Thanks a lot!

Okay, I have a problem that I need some suggestions with.
I have a 30 Gig database that I need to sync across a T1 every night.  This
database is a data dump of our billing system data, the tables are dropped
ad re-created every night.

My current project now is how to synchronize (data transfer) between
Production Database & Reporting Database using DTS, but I have no idea
how to do it and using which the best method. Need to know, that two
database have different structure tables - of course - and have a