I need some help on how to improve performance when loading tables. We have a datawarehouse and sometimes it is needed that the entire datawarehouse is refreshed. (like when test is refreshed from production) The datawarehouse tables are refreshed by a set of sql statements. Take for examp...more >>

I have a partioned view called members. Partined based on status of the members. Tables : members_11 ( check status=1) members_22 (check status>1) primary key ( memberid , status) View: members -- create view members as select * from members_11 union all select * from members_22 Th...more >>

Cam someone recommend a good newbie book for Analysis Services? One with step by step labs would be ideal. TIA, ChrisR ...more >>

Hi, I want to display some numbers in a map. These numbers come from a data warehouse and/or an OLAP cube I'm looking for a webbased tool. I want to display some colors linked to some values and I want to display specific "push pins" associated to specific postal code numbers. The target ...more >>

Hello, I am very perplexed with this problem I'm having. I work for a website-based company and my job is to create a data warehouse based on usage of the site. We have a Central Logging Database that logs every single hit to the site, then i have a stored procedure that picks up these hits, d...more >>

Hello, I am very perplexed with this problem I'm having. I work for a website-based company and my job is to create a data warehouse based on usage of the site. We have a Central Logging Database that logs every single hit to the site, then i have a stored procedure that picks up these hits, d...more >>

Are there any routines out there that will automatically convert a table (A) with numerous numeric fields to a new table (B) with just one numeric field. Thus the number of records in the table (B) would be the number or records in A mutliplied by the number of numeric fields. Thanks in advan...more >>

We are using BI Accelerator and we faced the problem that it is not possible to insert new rows. We have some shared dimensions and when we define cubes we also have to add list of dimensions. Very quickly we fill in the whole space of the worksheet. The worksheet is protected and basically we...more >>

Hi, I need some advise. We are in he process of designing our first data mart. This Datamart will consists of sales orders activity. Sales orders have lines created, deleted and inserted on a daily basis as long as the sales order is open. It has been suggested that we do triggers the the...more >>

For example, say I have a purchase fact table. Then I have a customer dimension. In the customer dimension, we have city, state, name, etc, and then we have a group level that needs to have a heirarchy exposed. For example: Super Super Level 1 Super Level 2 Good ...more >>

Hello all, I'm getting unexpected behavior when running DBCC SHRINKFILE on my 9 GB data file. First, it's been running in excess of 10.5 hours now and, second, it is ever-so-slowly *growing* the used portion of the file. For instance, when I look at the 'Space allocated' section of the Task...more >>

Hello, I hope somebody can help in solving next problem. Our SqlServer 2000 (installed on Win2003 EE) processes 15 millions of records each day. It works fine about 7-8 days and then it starts to slow down. Sometimes it seems that processing is stopped. There are also periods where everything...more >>

I am working with a report generator that is based on SQL Server 2000 and uses ASP as the UI. Basically we have a set of reports that end users can execute through a web browser. In general the model works fine, but we are running into some scaling issues. What I'm trying to determine is, what...more >>

OK, here's the situation: The "data warehouse" that our ERP provider sold us has evolved into more of an operational data store. We are in the process of developing a more traditional star-schema data warehouse. The ODS is getting quite large, currently at 150 GB. The server has 4 SAN dr...more >>

Greetings, I'm new with data warehousing. Just wondering, do any of you know of a free sample/example that would help me learn the ABC's of data warehousing? The SQL 2000 sample is only available with SQL Enterprise.. Thanks in advance, Don *** Sent via Developersdex http://www.develop...more >>

Hello, im trying to extract and merge data from several tables into one table, to indetify which table each row of data has come from I would like to insert a column which references the table name. Below is an example of the code:- I would like to create a column which will show for example ...more >>

For e.g I want the amount of a customer between 2nd March 2004 and 2nd October 2004. Basically How to filter this as i cannot put it in a where clause.i.e customer name in rows amount in columns....more >>

We had a stored procedure that was created while ansi_nulls was on. Is there a way to tell if SP has any of the ansi settings changed from default? Just curious. Sk ...more >>