Hi Profis! We have some server installed with customer, which run in an exclusive domain (only this server and because of that also DC). Let's call him "OLAP-Server". All the clients are in another domain. Access to "OLAP-Server" via HTTP works fine, also mapping of a drive (with manu...more >>

Hi, I'm looking at using checksum to check for changes in our data warehouse, and have seen comments on the checksum not always being unique. Just wanted to know how it is actually calculated to see if it is likely to get duplicated checksums. Thanks. ...more >>

I have a fact table which holds historical records. This table is increasing exponentially in size. To date there're already over 10 million records. I'm having trouble maintain this table on updates and queries. Can anyone recommend any way to deal with this? Thanks. ...more >>

Hi, I have a DTS package where I load 1.5 millions of rows in a staging table, and I perform multiple updates. 1 of these updates update the entire table by doing a simple lookup in a small table. this update takes 30 minutes ! my file is on a Raid 0 I have tried to update by batch (s...more >>

Hi, I'm still new to datawarehousing and right now I'm stuck on ETL. So can anybody give me some links to a good online resurces about ETL technics. Thanks, Marius ...more >>

Hi All, I was browsing for recent articles and saw the attached... Unisys also released a benchmark TPC-H on a 16 processor windows machine.... But my question is how well is win 2003/sql server 2005 scaling on windows now? I've recently upgraded some software I developed to provide unlimi...more >>

I am having a problem with bulk insert when the data in the input file contains a decimal point. I have given a shortened example below, in reality the table has about 500 columns and about 5,000,000 records were inserted sucessfully before records with decimal points were encountered. I have ve...more >>

Hi all, hope I am in the right newsgroup! I was looking for insight into a data warehouse design decision. We are going to have multiple sql2000 production servers (Px) and multiple sql2000 reporting servers (Rx) each paired at a remote location on their own individual LAN. All pairs will ...more >>

Hi all, We have two star schemas built into our warehouse: one called vehicle data and one called parts data. For some reason the warehouse was built with these quite separate 'data marts' (not sure if that's the right term)? Even though the parts will always relate to the vehicle. ...more >>

Hi, The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC is very very slow. What can I do? I have SP4 for Analysis Services installed. I thought SP4 could correct the problem but it did not. When I looked at the Analysis Services in MMC, the PC icon had a small red ...more >>

Hello, I’m looking for some help with analysis services. I ahve a very simple fact table which has 2 columns Account Number and Investment Objective. Fact table Account Number Investment Objective 12345678 A 22222222 A 33333333 B 44444444 X A dimension is needed for the investm...more >>

-- Thanks ! ...more >>

Hi, I'm using MS SQL Server 2000 with Analysis Services and have already created some cubes with mathematical functions for numerical values. The Problem is, that I also have to represent some text values in my application, and for having a similar interface I would like to create a cube fo...more >>

Greetings! Recently I detached database from SQL Server 2000 Enterprise Manager. When I try to attach it, I got a message: Error 9003: The LSN (8855:5583:1) passed to log scan in database 'contacts' is invalid. I have SQL Server 2000 with SP3 installed. All MDF and LDF files are present. Pl...more >>

Hi, I found the network transfert rate low between my 2 servers during cube processes. I have a 2Gbps network and only 2% is used during loading while I can go up to 25% during "simple" file copy. what are the performance counter to follow during the loading step of my cube? what can I...more >>

Good day everyone I have two SQL tables. One is a "Data" table in it with the days in the dd/mm/yyy format. Another "Time" table has the dd/mm/yyy , Month, Quarter , Year in it. I want to truncate the "Data" table but only where the Month is equal to current month. Rather than puttin...more >>

I have 5 cubes. All use shared dimensions in the same Analysis Services database. In a DTS package, I first fully rebuild the dimensions and the structure, and, no dimension has the changing dimension property. After all the dimensions are fully reprocessed, I fully reprocess each cube, but...more >>

Hi~ I would like to use Visio to draw a database model, then, "TRANSFORM", this chart to a physical SQL Server database in MS SQL SERVER 2000. Which version of Viso should I use? Would Visual Studio.NET 2003 have this feature? Thank you~~~ Annie...more >>

-=-=- Sorry for the dup post, I'm posting it under my MSDN universal acct now :) -=-=- Okay, I have a problem that I need some suggestions with. I have a 30 Gig database that I need to sync across a T1 every night. This database is a data dump of our billing system data, the tables are dro...more >>

Okay, I have a problem that I need some suggestions with. I have a 30 Gig database that I need to sync across a T1 every night. This database is a data dump of our billing system data, the tables are dropped ad re-created every night. I can do a very long and laborious process on the serv...more >>

My previous post drew no responses so I thought I would restate the problem. There is OTP data for which an overall OLAP %value is required. i.e. number of say bad eggs over total number of eggs gives performance of farm. Problem is that because there are many types of egg failures there is an ...more >>

Where can I find some real examples or some articles/links of real time BI with SQL 2K ? ...more >>