I'm looking into learning how to use Analysis Services- the problem , (for
learning purposes)  I have set up is 1,000,000 rercords , which are made up
of opinions about various topics . It is one column , with up to 1000
length.

Does anyone know if you can exclude tables from a cube in the Analysis Server?
Meaning, when creating a cube off of a database and you do not want to
include all the DB tables, how can you exclude them?
Thanks

I have a small problem when trying to process the cubes in AS. We have a
datawarehouse and have done couple of cubes also. In the beginning the cubes
processed fine, but after a while I have begin to get lots of errors. The
error message is "The attribute key cannot be foun. The ...

I am currently looking to get some insight into the BI-world (in the context
of SQL Server), and I find the distinction between datawarehousing and OLAP
somewhat vague.
My say would be that OLAP could be a part of a data warehouse, but it is not

I am using roles in a cube to limit what data a user can see. When I go into
the cube browser and select the "change user" option and select a specific
role, the security works fine. However, when I log in as a user that is
clearly defined under that role, it doesn't take effect. ...

Hey Everyone,
    I have both SQL 2000 and SQL 2005 Standard, I was wondering how tough
it would be to offer data warehousing I have an OC12 backbone and I am on a
t1 burstable so bandwidth would not be a problem, Where would I start if I

Is there any difference between:
executing 2 queries in the same database at the same time
or
Executing 2 queries in 2 different databases at the same time

I'm new to OLAP and especially drillthrough and just have a question about
the way it works.
I can see clearly why the process exists and the complete benefits of it,
but correct me if i'm wrong but:

Not sure if this is the right forum...
I have a fact table that ha sits own filegroup on a dedicated RAID 10 array.
Somewhere in Books Online I read that you should create a file in the
filegroup for each CPU in the server.  My understanding is that in SQL 2000,

I would like to ask, is there any way i could migrate data on my SQL Server
7 to SQL Server 2005? Is there any available white paper or article regarding
this? Kindly refer one to me.
Thanks in advance.

I'm looking for a SQL 2005 query to do a running sum to do this:
I want to identify the first day when an employee reached 20% of absences.
I have 2 table:
Absences (by activity, day, employee...)

Ingen
=====
GA - Georgia
--County1

Is it recommended to keep primary keys limited to a single field?
I have an account_id in all tables, and I wanted to make the rec_id in all
tables unique within an account_id, so the primary key would be based on
account_id + rec_id.  I like the idea of each Account starting at 1 ...

A beginner's question...I would look up the answer myself if I had the time,
I'm in a bit of a hurryy...
Indexes vs Statistics:
Does running sp_updatestats mean that all indexes in my database is updated?