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...
Jéjé
08-10-2005 11:19 AM
Jéjé Go to last post
2 1,622
What is Datawarehouse and How can we take benefit out from it. ??
Manish
08-10-2005 09:13 AM
Peter Nolan Go to last post
2 127
I have a POITEM Table which has just three columns InvetoryID, DateofOrder, VendorID I have under the same InventoryID ,multiple DateofOrders and...
Sam
08-10-2005 08:16 AM
Sreejith Go to last post
6 141
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...
karenmiddleol@yahoo.com
08-06-2005 12:12 PM
Mark Malakanov Go to last post
6 263
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 02:09 PM
Akinja Go to last post
4 132
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 10:16 AM
Dave Wickert [MSFT] Go to last post
1 132
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...
Wreck
08-04-2005 12:20 AM
Wreck Go to last post
5 193
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...
yan
08-03-2005 06:10 PM
Mark Malakanov Go to last post
7 169
how difficult is it to convert access tables to SQL that can continue to be linked to an Access GUI.
mike
08-01-2005 05:01 AM
Peter Nolan Go to last post
1 124
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...
ricocali@hotmail.com
08-01-2005 04:59 AM
Peter Nolan Go to last post
3 178
I'm looking for some advice/tips on implementing DW on SQL server with data from Oracle databases. What are the common problems, best...
MC
08-01-2005 04:48 AM
Peter Nolan Go to last post
3 132
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 04:00 PM
Peter Nolan Go to last post
5 169
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...
Jéjé
07-21-2005 08:44 AM
Mumtaz Zaheer Go to last post
7 169
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...
Nacho
07-21-2005 02:25 AM
Dave Wickert [MSFT] Go to last post
4 138
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...
Tom
07-21-2005 02:21 AM
Dave Wickert [MSFT] Go to last post
1 135
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...
Mark00
07-20-2005 05:05 PM
Peter Nolan Go to last post
4 130
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...
§Chrissi§
07-20-2005 01:50 PM
BeWyched Go to last post
3 613
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'...
marcmc
07-20-2005 04:07 AM
Mumtaz Zaheer Go to last post
1 118
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 10:13 AM
JT Go to last post
4 112
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...
Jéjé
07-18-2005 09:33 PM
Jéjé Go to last post
2 638
Hi, We have an application that access multiple databases for generating reports and running various queries. These databases are segregated as...
Ajay
07-12-2005 08:20 AM
Peter Nolan Go to last post
5 123
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...
SolarCoder
07-12-2005 08:14 AM
Peter Nolan Go to last post
3 112
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...
Jéjé
07-10-2005 05:43 AM
Peter Nolan Go to last post
12 237
Hi, I have read the SQL 2005 features comparison and I have some questions: (http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx) *...
Jéjé
07-08-2005 11:43 AM
Peter Nolan Go to last post
5 148
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 11:19 AM
Peter Nolan Go to last post
3 146
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 11:10 AM
Peter Nolan Go to last post
4 125
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...
Resant
07-08-2005 09:04 AM
JT Go to last post
3 114
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,...
vidro
07-08-2005 07:51 AM
Danny Go to last post
2 127
-=-=- 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 07:17 PM
Scott M Go to last post
12 235
I work in consumer goods company and now design OLAP Data Warehouse. My OLAP tables consist of : 1. Customer - all our customer data {CustomerID,...
Resant
07-06-2005 10:08 PM
Resant Go to last post
2 161
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...
Annie
07-05-2005 07:22 PM
Jéjé Go to last post
3 142
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...
Jéjé
07-05-2005 07:58 AM
Jéjé Go to last post
2 128
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...
Newsgroupsupport
07-03-2005 11:00 AM
Jéjé Go to last post
2 119
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...
john1425
07-03-2005 10:39 AM
Jéjé Go to last post
1 118
Hi, I want to have your feedback on how to configure my drives to insure a good performance during loading process & transformation against a...
Jéjé
06-30-2005 06:27 PM
Jéjé Go to last post
2 134
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...
Carolyn
06-30-2005 07:59 AM
Carolyn Go to last post
2 172
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....
Nestor
06-29-2005 08:53 AM
JT Go to last post
1 140
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...
sgpgpjr@yahoo.ie
06-24-2005 10:40 AM
Sam Go to last post
2 128
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...
appdevtech
06-20-2005 05:33 AM
Peter Yang [MSFT] Go to last post
4 658
Hi, I'm using MS SQL Server 2000 with Analysis Services and have already created some cubes with mathematical functions for numerical values. The...
PhiberOptic
06-19-2005 10:45 PM
Jéjé Go to last post
1 119
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...
Jéjé
06-14-2005 01:33 PM
Jéjé Go to last post
3 130
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...
Granville
06-13-2005 02:23 PM
Michael C# Go to last post
2 163
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...
Tom
06-10-2005 09:50 PM
Tom Go to last post
2 131
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....
Bob
06-07-2005 11:30 PM
Myles.Matheson@gmail.com Go to last post
7 152
Where can I find some real examples or some articles/links of real time BI with SQL 2K ?
Hassan
06-06-2005 08:10 PM
Myles.Matheson@gmail.com Go to last post
1 117
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...
vvf
06-02-2005 12:20 PM
Saverio Tedeschi Go to last post
1 146
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...
Kelly
05-26-2005 09:17 AM
Kelly Go to last post
2 129
all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are working excelp OLAP services, i even restarted the server. In service...
Pravin
05-25-2005 05:21 PM
Mark Job Go to last post
1 125
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...
Adam
05-22-2005 06:49 PM
Michelle Campbell via SQLMonster.com Go to last post
2 216
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...
twahl
05-22-2005 12:57 AM
Alejandro Leguizamo \(MVP\) Go to last post
1 154
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 - 2014, Jelsoft Enterprises Ltd.