I know a data warehouse stores historical data and the fact and dimension
tables could be huge with billion rows and could be more than 100s of GB in
size for just one table. Can someone share some design tips on whether they
partition those fact tables based upon time and then ...

Right now we tend to provide extracts to our data warehousing system once a
day. Users seem to be presseing for near real time warehousing. It seems to
be a lot of processing to happen on the production side to get this data
during regular hours and hence the nightly extracts..

I have a little problem with a mdx query using topcount.
My query looks like:
SELECT
    {SOMEMEASURES} ON COLUMNS,

I am in a situation where I have a table which has Primary Key which is
actually IDENTITY Column as well. Now, I want to implement Partitioned View
on it. I went thru your different article about it in SQL Server Magazine but
I did not find how to handle this situation If I have ...

I just gone through a datawarehouse CD seminar for SQL2K
but a little confused on something.  The author said not
to use clustered indexes with star/snowflake schemas.  Is
there a reason for this?  The author never explained why

In general what's best practice for page density of indexes in a DW db?  
I can understand having space in a OLTP environment where page splits can
cause degradation in performance.  However,  is there really any need to not
have a fill factor of 100% in a OLAP DW environment with ...

What's the best way to archive tables with binary data?  Flat files/bcp/DTS
may not work if need to import binary data(not a fixed length column) with
quotes etc.  What I am thinking is to export to another database and back it
up/archive on a regular basis.  That way it will be ...

I have a set of disks available on my server (but 1 controller only). I want
to use it to improove queries performance...
I want to know what is better to improove the performance:
* moving all (non clustered) indexes on a separate file group on this set of

I'm new to OLAP, and just tried build OLAP & Data Warehousing using
DTS. Now I'm arrive at the step where I must concern about performance.
There some questions that I want to ask, there're:
1. Where should I store OLTP database and OLAP database, should they in

I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1

I get an error populating a dimension that says that there are over 64000
members.
The dimension only has one level.
Is that a limit, bug or am I doing something wrong?

I have an old Datawarehouse server with 8 disks
in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks.
I want to move these 4 drives to a new server (better processors).
My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000

I'm trying to design a large DB and considering which direction to go.
The planned login user accounts will be 10,000, and each user has 15 DB
Tables. Each Table's structure similar to other users, but user's data
records have no relation with each other.

How big can a database be in a sql 2000 and in SQL 7.0?? Is it 6 gig the
largest size!

I have a table with numerous text fields.  When importing the data the
transfer put in a space in all of the text fields instead of a NULL value.
Now the table size is much larger than it should be.  I have replaced the
spaces with a NULL value, but the table size has not shrunk. ...