all groups > sql server data warehouse > march 2004 > threads for march 1 - 7, 2004
Filter by week: 1 2 3 4 5
SQL Statement Problem
Posted by Atley at 3/5/2004 2:26:06 PM
Sorry for the wide posting, but i really need some help and I posted
somethind a few hours ago and have heard nothing, so i thought that I would
try reacing more developers...
I am trying to get a date range from the first of whatever month is previous
to the current one to exactly one year pr... more >>
Discussion: How to determine a Fact Table algorithmically
Posted by Girish at 3/3/2004 4:35:37 PM
I dont know the difference between OLAP and the datawarehouse newsgroups,
and i really dont know how many ppl frequent both the groups together - but
Im posting this topic here in hopes that it may start a discussion. I
apologies for any inconvenience. Thks. =)
------------------------------... more >>
Dimensions and Fact tables
Posted by Stephen at 3/3/2004 2:19:28 PM
If you have two fact tables that share a dimension is it better to duplicate
the dimension by adding a copy of it to the warehouse or should you share
the single dimension between the fact tables?
... more >>
Modelling Time Span with OLAP tools
Posted by Break It at 3/3/2004 4:01:06 AM
This is more of a design question. I am trying to create a fact table for time spans. For example an order might go through the following status of Created, In-Progress, Delivered. The time span between any 2 states could range from minutes to days to months. I want to be able to see the current sta... more >>
64-bit performance vs 32-bit performance
Posted by greedo at 3/2/2004 6:10:48 PM
Hi
Does anybody know of any official documents comparing 64-bit SQL Server
performance against 32-bit on a similar hardware platform? Apologies for
any cross posting that may have occurred only I need answer ASAP. Ideally I
need OLAP & OLTP benchmarks.
Regards.
... more >>
Is it possible?
Posted by Calvin Lai at 3/2/2004 12:51:15 PM
Hi all,
Say I have a table w/ a IDENTITY field as PK. Is it possible to change the
IDENTITY SEED of that filed programmatically thru SQL script or any other
method? Thanks for any input.
Calvin
... more >>
Clarifications on DW
Posted by Imran at 3/1/2004 6:54:54 PM
Hi,
hope someone could help me out with these issues I
have.
(1)when u do an extraction from the source database table
to the destination database table using DTS, does dts copy
only the data that is not available in the destination
table or does it Reload the entire sets of rows in ... more >>
|