Archived Months
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
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 >>



DevelopmentNow Blog