We're building a data warehouse to report on consulting revenue
(HoursWorked*BillRate) and Expenses.  We need to do things like determine
Gross Profit (GP) based on a consultant's loaded rate and by subtracting the
non-reimbursable expenses and costs from the revenue.  Should ...

The problem is decimal values gets truncated when passed from excel source
to data conversion object. Following is flow of SSIS package.
1. Source excel file, has a column amount.
2. Read the amount colum as text (imex=1 in connection string), as sometimes

We have been using MS Analysis Server with Axapta (a mid-range ERP from MS)
for quite some time.  So long we were able to create/run cubes without any
problem.
But today all of a sudden we are getting the following error message -

I have an SQL 2000 datawarehouse where my 2 biggest tables are partitionned
by year. (Fact_Table_2003, Fact_Table_2004,...)
I want to test to migrate to 2005 and I want to use the new partitionned
table options.

I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.
any one can help me?

I am using Yukon.
I am designing a datamart which should satisfy the OLAP browsing as well
as drill through reporting for which I think I may have to include some
other tables into my datamart which contains all the detail information for

So let's say i manage to construct a warehouse. And let's pretend i can
conjure a system to constantly bring in new data from the "live" system.
How do the computer illiterate end-users perform their own querying of my
warehouse?

Hi again (and again) guys...
I have just read an article in the SQL Server magasine which says that its
recommanded to have 1 file by processor for the tempdb database.
does this recommandation is good for a data warehousing solution?

I Got this web application runnin on Sql Server 2000
now using ACT to test a search function wit about 500,000 records in the
database,  gives me about 144RPS, but on two million records i get rates as
low as 8RPS

 I have some DSO code which is partitioning a cube very nicely by deleting
and recreating old monthly partitions by cloning an original month partition.
When I actually come to test the data present in the cube I only ever get the
the original partitions data.

Does anyone have any information on comparison between different databases
for datawarehousing?  I am working on a study to develop a datawarehousing
solution for my client, so I would like to get some information on
competitive aspects of SQL Server 2005 over DB2 and Oracle.

I have a datawarehouse which contain a historical table holding close to 100
million records... this table is growing exponentially. Everytime I process
my cube, data has to be read from this table and it is taking very long
before data is returned (between 2-3 hours)

Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft ...

I am trying to alter a large table (with 100+ fields) so the fields are
ordered alphabetically. Is there a quicker and smarter way of doing this,
other then manual one-by-one?
Thanks,

I run the following query "SELECT * FROM tbl_A", and get the following
result set:
Surname       Firstname
Smith           John