We want to create a reporting database from our OLTP database.  We are
thinking to take an initial snapshot and then use transactional replication.
However, we also want to keep the OLTP database with only one year of data.
If after one year, we remove records from OLTP, the ...

Can anyone recommend a good book on designing and implementing a data
warehouse using sql server specifically?  Not just one in your library, but
one that stands-out?
Thanks,

how can i use COL_NAME in where?
SELECT *
FROM table
WHERE COL_NAME(OBJECT_ID('tableTTT'),6)=value_to_compare

To anyone who can help,
    I am reviewing the processes in the Analysis Manager, and I am going
through the sample exercises offered by SQL Server's Analysis Manager Help.
   So far, every step has been successful, but now I am running into a

i want to create offline cubes in excel 2003 and receive
following  error message:
Microsoft OLE DB Provider for Analysis Services:
Data source provider error.

I am following the tutorial to create a Parent-Child dimension Account. Why
cann't I see the step "Set dimension write-back capability"? I am using SQL
2000 Standard.
Thanks

Hello there, my datawarehouse uses SQL 2000 enterprise as
database. When the ETL process runs it takes all the
memory of my server (aprox 2gb) and when it finish, the
memory stay freeze, an the task manager shows that the

I would like to find out what is Microsoft's Position in terms of Master
Database/Data Management Solutions. I was looking at one article where SAP
talks about Master Data Management and here is what they say :
SAP Master Data Management is the foundation for harmonized, consistent

I have an SQL Server 7 transaction Database for which I want to implement
OLAP.
I had a play around with OLAP using SQl server 7 but I now wish to give it a
go using an SQL  server 2000 platform.

I created a cube with 2 Snoflakes dimension.  The first
dimension use table A and table B.  The second dimension
use table C and table B.  
When my both dimesion was created, my fact table is join

As we all know that there are two approaches of implementing a data
warehouse project. One is the top-down approach where in we create the
central data warehouse first, and then we go about creating different data
marts. Another approach is Bottom-up where in we create individual ...

How to refresh data for a day in a cube. I want to do this without deleting
the records from the fact tables for the specified day.
--
Regards,

I has a strange question.
My company is using a old system with Win NT 4.0 Server + MS SQL 7.0.
The system is busy and handle a lot of SELECTs and INSERTs all the time.
Sometimes, some transactions are blocked by some other transactions.

My company is looking at several vendors of BI software for our data
warehouse.  We have never had a data warehouse before and are learning
everything from scratch.  Does anyone have any opinions on the
following vendors...

we developped a software with a data warehouse in sql server, without using
analysis services, and following the star design.
we are working with data about transactions, with caracteristics modeled in
dimensions. in general each transaction has one single value for each