I have a historical table that is over 100 million records in size. Processing this table in AS takes an extremly long time (about 2 hours). Is there any way to speed this up in AS? ...more >>

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 this be one fac...more >>

Guys I am trying to demoralize the source column in one of my tables so I can identify the combination of sources that the email was recruited from. I know I can do this with a while loop (or cursor) but I would really prefer taking a set based approach. Also, please feel free to offer...more >>

Hi, SQL 2000 AS. I have a dimension table 'Periods' example : 1 = Jan 2005 2 = Feb 2005 3 = Mar 2005 etc. NB This is not a standard time dimension. The table has a key on 'PeiodID' = 1, 2, 3 etc. My Fact table has say 2 period entries per row (say Billing, Collection) - these can...more >>

Hi, I'm trying to write a MDX query resultset from a cube to a database table via an SSIS package. I create an OLE DB source in a data flow and choose OLE DB Provider for Analysis Services 9.0 as the connection manager. Then I run it through some node afterwards but it's the OLE DB source node...more >>

Please pardon my ignorance here, but I'm a newbie with MS SQL Server. I have a database that contains a table with 33.6 million records. When I built the table I used Nvarchar in several of the fields. Now I'm thinking that because the db size is 7.5 gb, that I could reduce that by changing...more >>

A while back, I had the worst 6 month period of my life. It was awful, every day I would come home from work in a bad mood and stressed. Every day I would go to work dreading yet another day. Why did my life suck so bad? Because I was a full time query writer. Every day I would get requests for ...more >>

Hi, 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 it may have text data by m...more >>

Hi, 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 - .......................................................more >>

Hi, 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. how to do this easely? thanks. Jerome. ...more >>

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 the drill through reporting. The design that I ha...more >>

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 my Server runs on a P4 3.2GHZ, 1 GB Ram, 250GB sata HDD does anyone have bett...more >>

Hi, I'm trying to implement a recency measure for my individual customers, telling me how many days have gone by since the last purchase of a customer. I would like it to go something like this: with member time.week.last_purchase_date as 'Tail(Filter([Time].[Week].[Date].members, Not ...more >>

Hi, 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. If I use the partition ...more >>

Hi, 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. Thanks ...more >>

Hi all, 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) Is there an...more >>

Hi, I run the following query "SELECT * FROM tbl_A", and get the following result set: Surname Firstname Smith John Smith Richard Smith Simon What I want to see in my result set is: Surname Firstname Smith John, Richard, Simon ...more >>

Hi, 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, Zoran...more >>

Hi, I am new in designing a data warehouse. Does it makes sense to have a dimension table called AGE where maybe numbers from 10 - 100 are in it? Maybe I should callculate the age in my query ?! I think it is OK to have a TIME dimension wich is responisble for the birthday, and other dates in...more >>