dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.datawarehouse microsoft.public.sqlserver.datawarehouse

Discuss in the microsoft.public.sqlserver.datawarehouse forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.datawarehouse Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi, I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH wait type. The update is blocked by himself (using the sp_who1, I see...
08-10-2005 10:19 AM
Jéjé Go to last post
2 1,631
What is Datawarehouse and How can we take benefit out from it. ??
08-10-2005 08:13 AM
Peter Nolan Go to last post
2 131
I have a POITEM Table which has just three columns InvetoryID, DateofOrder, VendorID I have under the same InventoryID ,multiple DateofOrders and...
08-10-2005 07:16 AM
Sreejith Go to last post
6 150
I have a data modelling challenge I need to store multiple values in the attributes of a dimension. The dimension I need to model is the...
08-06-2005 11:12 AM
Mark Malakanov Go to last post
6 269
Can sombeody point me in the right direction. How can I convert a relational database to a datawarehouse? Thanks
Luis Esteban Valencia
08-05-2005 01:09 PM
Akinja Go to last post
4 140
Hi! I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an SQL Server Analysis Services Server. This works fine and I'm hapy with...
Jérémie Gent
08-05-2005 09:16 AM
Dave Wickert [MSFT] Go to last post
1 137
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...
08-03-2005 11:20 PM
Wreck Go to last post
5 197
We have a table which data is over a million but less 2 billion. We define an integer field to hold primary keys but we do not like to choose GUID...
08-03-2005 05:10 PM
Mark Malakanov Go to last post
7 176
how difficult is it to convert access tables to SQL that can continue to be linked to an Access GUI.
08-01-2005 04:01 AM
Peter Nolan Go to last post
1 131
We have an anomaly where over time the hierarchy of a dimension changes. With that, we are only allowed to have "1" hierarchy. It is basically an...
08-01-2005 03:59 AM
Peter Nolan Go to last post
3 184
I'm looking for some advice/tips on implementing DW on SQL server with data from Oracle databases. What are the common problems, best...
08-01-2005 03:48 AM
Peter Nolan Go to last post
3 139
I have a problem in one of my production server: the rows number is exactly 2 billion records and when you do delete, insert, that row number was not...
David Liu
07-22-2005 03:00 PM
Peter Nolan Go to last post
5 174
Hi, I'm looking for samples models for an HR model and specially the employee dimension table. What is better a slow changing dimension (with full...
07-21-2005 07:44 AM
Mumtaz Zaheer Go to last post
7 178
Hi. I have Question.. If possible install the olap server with winXP to make cubes in my computer non in the server to practices? if is yes, what am...
07-21-2005 01:25 AM
Dave Wickert [MSFT] Go to last post
4 142
Hi, I have an Analysis Services database that contains 5 cubes. Is it possible to migrate the database and cube roles from a development machine to...
07-21-2005 01:21 AM
Dave Wickert [MSFT] Go to last post
1 140
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...
07-20-2005 04:05 PM
Peter Nolan Go to last post
4 137
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...
07-20-2005 12:50 PM
BeWyched Go to last post
3 619
I have about 16 new columns I am bringing into the datawarehouse from an AS400 system. Getting them in is no problem. I need to 'massage'...
07-20-2005 03:07 AM
Mumtaz Zaheer Go to last post
1 125
Hi There, I got a generic DW question. Let me preface this I need to design a report that displays data for 3 branches of same companies, Branch A...
ERS Developer
07-19-2005 09:13 AM
JT Go to last post
4 118
Hi, I have some issues with a server which is connected to a slow SAN. the iometer utility says: SAN= 260io/sec - 8mb/s (32kb block...
07-18-2005 08:33 PM
Jéjé Go to last post
2 655
Hi, We have an application that access multiple databases for generating reports and running various queries. These databases are segregated as...
07-12-2005 07:20 AM
Peter Nolan Go to last post
5 128
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...
07-12-2005 07:14 AM
Peter Nolan Go to last post
3 119
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...
07-10-2005 04:43 AM
Peter Nolan Go to last post
12 243
Hi, I have read the SQL 2005 features comparison and I have some questions: (http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx) *...
07-08-2005 10:43 AM
Peter Nolan Go to last post
5 154
I have been arguing with my partner if we shoud or not design a normalized data base or denormalized. How, can we know when we should choose one or...
Lina Manjarres
07-08-2005 10:19 AM
Peter Nolan Go to last post
3 151
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...
Scott M
07-08-2005 10:10 AM
Peter Nolan Go to last post
4 132
My current project now is how to synchronize (data transfer) between Production Database & Reporting Database using DTS, but I have no idea how to do...
07-08-2005 08:04 AM
JT Go to last post
3 120
SQL 2000; I have a table that has info from 2001 thru 2005, I want to create new tables and move records from the original table to the new tables,...
07-08-2005 06:51 AM
Danny Go to last post
2 134
-=-=- 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...
Scott M
07-07-2005 06:17 PM
Scott M Go to last post
12 240
I work in consumer goods company and now design OLAP Data Warehouse. My OLAP tables consist of : 1. Customer - all our customer data {CustomerID,...
07-06-2005 09:08 PM
Resant Go to last post
2 169
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...
07-05-2005 06:22 PM
Jéjé Go to last post
3 147
Hi, What is the -E switch in SQL Server? (not -e but -E) I have read this: SQL Server can allocate 4 extents instead of 1 extent when the -E switch...
07-05-2005 06:58 AM
Jéjé Go to last post
2 134
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...
07-03-2005 10:00 AM
Jéjé Go to last post
2 125
hi i want to load Data from 2 sources (access and mysql) the 2 source have same schema ;how to load to cube the data and retrive the data of...
07-03-2005 09:39 AM
Jéjé Go to last post
1 121
Hi, I want to have your feedback on how to configure my drives to insure a good performance during loading process & transformation against a...
06-30-2005 05:27 PM
Jéjé Go to last post
2 137
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...
06-30-2005 06:59 AM
Carolyn Go to last post
2 177
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....
06-29-2005 07:53 AM
JT Go to last post
1 145
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...
06-24-2005 09:40 AM
Sam Go to last post
2 132
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...
06-20-2005 04:33 AM
Peter Yang [MSFT] Go to last post
4 703
Hi, I'm using MS SQL Server 2000 with Analysis Services and have already created some cubes with mathematical functions for numerical values. The...
06-19-2005 09:45 PM
Jéjé Go to last post
1 139
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...
06-14-2005 12:33 PM
Jéjé Go to last post
3 137
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...
06-13-2005 01:23 PM
Michael C# Go to last post
2 170
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...
06-10-2005 08:50 PM
Tom Go to last post
2 134
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....
06-07-2005 10:30 PM
Myles.Matheson@gmail.com Go to last post
7 158
Where can I find some real examples or some articles/links of real time BI with SQL 2K ?
06-06-2005 07:10 PM
Myles.Matheson@gmail.com Go to last post
1 121
Hi, Please help me with the following scenario: I want to implement an application using eMbedded Visual C++ 3.0 (and then 4.0) to capture data...
06-02-2005 11:20 AM
Saverio Tedeschi Go to last post
1 150
they want to pass data between several distinct dbs on diff server groups. I'm way new to sql server and not sure it can be done. Help! I...
05-26-2005 08:17 AM
Kelly Go to last post
2 135
all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are working excelp OLAP services, i even restarted the server. In service...
05-25-2005 04:21 PM
Mark Job Go to last post
1 129
Hello, I'm trying to decifer the data in the table that stores the data in the binary format. All numbers are placed in varbinary fields. All I know...
05-22-2005 05:49 PM
Michelle Campbell via SQLMonster.com Go to last post
2 221
SQL Express is limited to 1 CPU. What are the ramifications to installing it on a system with multiple CPU’s? Will it simply bind to one of the...
05-21-2005 11:57 PM
Alejandro Leguizamo \(MVP\) Go to last post
1 158
Post New Thread

Display Options
Showing threads 551 to 600 of 1147
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.