 Improving the Sql environment at our Place ? [0 replies]
microsoft.public.sqlserver.datawarehouse, Saturday, January 28, 2006
I need to improve the sql setup at my current location (long term contract)
Currently there are
100+ msde installations (1 gb average running a retail back end processes)
Backup to dis...
DTS migration to Oracle [0 replies]
microsoft.public.sqlserver.datawarehouse, Friday, January 27, 2006
Hi!
Do you know any tool ou method to help the migration of an entire DW
repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation
Services too... I think it is veru d...
building a web site [0 replies]
microsoft.public.sqlserver.datawarehouse, fri,
I just got back working on my website. Its taken a long time to finish but I am getting there.
I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a ...
sql Insertion Speed [1 reply]
microsoft.public.sqlserver.datawarehouse, Friday, January 27, 2006
I have tens of thosands of records needed to be insert to SQLserver on each
query.
My experience is that each 10 thansands records needs 7 sec.
Is there any method to increase the speed?
(I...
Zero Values [2 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 26, 2006
I am building a fact table containing 6 measures. For about 90% of the
rows, 3-4 measures will be zero. What is the best data type to use for
the measures?
Ad-Hoc Reporting on DW with many Slowly Changing Type 2 Dime... [3 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 26, 2006
A requirement of our DW project is that we store Dimensional changes,
and it appears the SCD Type 2 method sounds best for that.... But say
you have 30+ Dimension tables, all SCD T2. Another...
DTS Documentation Generation [0 replies]
microsoft.public.sqlserver.datawarehouse, Tuesday, January 24, 2006
There is a nice DTS Documentation generator called DTS Documenter:
http://www.softrus.org/dts/
It will document Data Steps, Data Tasks, fields mappings
and even the Package call tree.
...
percentage based on the current filter [0 replies]
microsoft.public.sqlserver.datawarehouse, Tuesday, January 24, 2006
Hi to all,
I built a calculated member showing the percentage of a certain
measure over more dimensions.
For example,
I have 3 dimensions, d1,d2 and d3 and a measure m1. My calculated
mem...
MDX Filtering help!! [1 reply]
microsoft.public.sqlserver.datawarehouse, Monday, January 23, 2006
Heres my scenario:
I have a dimension which has levels. For example, I have this:
7ZZZZ
70ZZZ
71ZZZ
72ZZZ
73ZZZ
And I need to make a calculated cell which will zero out a...
performance tuning [0 replies]
microsoft.public.sqlserver.datawarehouse, Monday, January 23, 2006
hi,
this is srinu.
1) How can we increse session performane?
2) what is update strategy transformation ? where we can use it?give me
one exmple?
bye,
srinu
performance tuning [0 replies]
microsoft.public.sqlserver.datawarehouse, Monday, January 23, 2006
hi,
this is srinu.
1) How can we increse session performane?
2) what is update strategy transformation ? where we can use it?give me
one exmple?
bye,
srinu
topic on lookup transformation [0 replies]
microsoft.public.sqlserver.datawarehouse, Monday, January 23, 2006
hi,
this is srinu.
my questions r 1) what is lookup transformation and in which situation
we use ?
2) what is difference between static and
dynamic?
i am awati...
good DW cert? [0 replies]
microsoft.public.sqlserver.datawarehouse, Sunday, January 22, 2006
In the world of Data Warehousing, is Analysis Services a hot ticket? Is
this a tool that most business' are using, or are a lot of them going 3rd
party? If so, what are they? Ive been a SQL ...
Free Hot Phone Sex [0 replies]
microsoft.public.sqlserver.datawarehouse, Saturday, January 21, 2006
100% Free multi-lingual
AnimalSperm Production
elmar
Free Hot Phone Sex [0 replies]
microsoft.public.sqlserver.datawarehouse, Saturday, January 21, 2006
100% Free multi-lingual
AnimalSperm Production
elmar
ow to simplify what i'm doing (AS the solution?) [1 reply]
microsoft.public.sqlserver.datawarehouse, Saturday, January 21, 2006
i need to do create reports that perform queries where the results are
percentages of total count divided by counts based on different
subquery where values.
a la ...
select 100 * (tota...
indexing [0 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 19, 2006
whata is the difference between B-Tree and BitMap Indexing?
Examples on BitMap?
SQL 2000 Analysis Manager [0 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 19, 2006
Is it possible to see right panel of the Analysis Manager (SQL 2000) in HTML
mode in LIMITED USER mode on a Windows XP machine? I can only see it in a
Admin mode. Your help will be apprecia...
Comparing datetime fields results in slow query performance [2 replies]
microsoft.public.sqlserver.datawarehouse, Wednesday, January 18, 2006
Hi,
I am currently deduping a data warehouse containing around 3 million
records. Most of my dedupe scripts run in 3 or 4 minutes but the
scripts which compare datetime fields take up to 3...
Free mp3's [0 replies]
microsoft.public.sqlserver.datawarehouse, Wednesday, January 18, 2006
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>And much more that that!</P>
<P><A href="http://forum.saait.net/">http:/...
Having trouble sorting numerical data from SQL analysis cube [3 replies]
microsoft.public.sqlserver.datawarehouse, Monday, January 16, 2006
I've built a cube with a numerical dimension in SQL 2000 analysis
services. When I add that dimension as a column, it sorts as follows
1
10
100
2
20
instead of
1
2
10
20
1...
Which Model? Relational Or Multidimentional Model? [1 reply]
microsoft.public.sqlserver.datawarehouse, Saturday, January 14, 2006
Hi, i Studied Both Relational and Multidimentional model for Data Warehousing,
but i don't know which is the best to do? can u Please Guide me?
Thx
--
Message posted via SQLMonster.com
...
online sites [0 replies]
microsoft.public.sqlserver.datawarehouse, Friday, January 13, 2006
Hi,
Can anyone tell me what are the good online resources for
Datawarehousing and olap. I know little bit about them and also have
some books but I am looking for some online sites.
T...
USERS [1 reply]
microsoft.public.sqlserver.datawarehouse, Friday, January 13, 2006
Is there anyway to find how many users connected to cube
thanks
Kalyan
GET BPI CARD FOR GETTING MAX. DISCOUNTS AND BENEFITS [0 replies]
microsoft.public.sqlserver.datawarehouse, Friday, January 13, 2006
GET BPI CARD FOR GETTING MAX. DISCOUNTS AND BENEFITS
ashok - Jan 13, 1:13 pm
BUSINESS PLUS INDIA IS LOOKING FOR THEIR MARKETING ASSOCIATES FOR ALL
OVER INDIA DEAR SIR/MADAM THE GROUP OF BUSI...
Solve Order for Calculated Members [1 reply]
microsoft.public.sqlserver.datawarehouse, Wednesday, January 11, 2006
Dear All,
Hope anyone can give me ideas on how to solve this problem.
I have a cube with some calculated measures. The application that access
this cube uses query-scope calculated member...
Optimizer not using Indexed View [3 replies]
microsoft.public.sqlserver.datawarehouse, Tuesday, January 10, 2006
Hi All
We are having problem on indexed views when we try to join to more than one
table that is not part of the original indexed view in a query. Has anybody
seen a similar problem?
...
Granularity Manager [1 reply]
microsoft.public.sqlserver.datawarehouse, Tuesday, January 10, 2006
ANy body can Introduce me a White Paper about Granularity Manager, or A tool
for this Purpose?
--
Message posted via http://www.sqlmonster.com
Cube processing but not showing data [1 reply]
microsoft.public.sqlserver.datawarehouse, Monday, January 09, 2006
Hi all,
SQL 2005 SP3, AS 2000
I have a cube that is processing but is not showing any data when I browse
the data. The fact and dimension tables have data and there are no null measures
...
MDX queries [1 reply]
microsoft.public.sqlserver.datawarehouse, Monday, January 09, 2006
Hi ,
I am planning to do datawarehousing and develop some cubes but i am not too
sure of how to use MDX queries .
Where can i get help on MDX queries ?
appreciate ur advise
tk...
How can I pass the file to sql server ? [0 replies]
microsoft.public.sqlserver.datawarehouse, Sunday, January 08, 2006
I have created a component which parses some flat
files and stores in Sql database. Now I want to move
that COM object to database server.
Now the scenario will be like this :
1) ASP pa...
Should I use a composite Primary Key [0 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 05, 2006
Currently we have 5 systems that I am copying data from into my
datawarehouse. The table structures are all identical in that each system has
a primary key on uniqueID (int, identity) When ...
Locking while updating [5 replies]
microsoft.public.sqlserver.datawarehouse, Thursday, January 05, 2006
We are currently using VB to create order numbers. Each user requests an
order number as and when required. The problem is that the next in the
sequence seems to be allocated on the odd occ...
DBMS For Datawarehousing [2 replies]
microsoft.public.sqlserver.datawarehouse, Wednesday, January 04, 2006
Hi, which DMBS Do u Prefer For a DW?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-data-warehouse/200601/1
database for datawarehouse [1 reply]
microsoft.public.sqlserver.datawarehouse, Monday, January 02, 2006
Hi,
I'm doing a course in datawarehousing. I need some dataset to make a
project. Does anyone know where in net can I find datasets appropriate
to create datawarehouse?
Thanks all
Measure change updates in Fact tables [3 replies]
microsoft.public.sqlserver.datawarehouse, thu,
Is there an industry standard method to populate Fact table columns with the
amount of change of a measure from one row to the next?
I have a FactSubscriptions (1 row = 1 week), and I wol...
|
