Strategies and Ideas

• Topics

  Started by

  Posts

  Last post

• optimal server placement

  Just took new job, we have one server that has a read-only log shipped copy of major database, it a…

  tcronin 95651

  1 replies

  11 years, 2 months ago

  By: Thomas LeBlanc

• Using surrogate keys for

  I'm working on my first data warehouse project and was wondering what is the industry norm when it …

  emiranda 59653

  7 replies

  11 years, 2 months ago

  By: emiranda 59653

• Books on implementing data lineage

  Hi, We are currently working on implementing the data lineage within our data warehouse and I don't…

  newbie_dev

  3 replies

  11 years, 2 months ago

  By: newbie_dev

• Products that change ProductID's HELP///

  So i came across my first spanner in the works in building my product dimension our products can be…

  ps_vbdev

  3 replies

  11 years, 2 months ago

  By: ducon

• Data Dictionary Table in Staging Database

  We are trying to extract flat files into a staging database. The extracted data from the flat file…

  imani_technology

  6 replies

  11 years, 2 months ago

  By: imani_technology

• EFFICIENT Front End for SQL Server

  I know there's been many questions about SQL front ends, but I have some specific requirements I ha…

  mjd327

  13 replies

  11 years, 2 months ago

  By: mjd327

• Recording why a change happened using MERGE with Type 2 SCD

  I have a few fields in my staging DimProducts that are type 2 scd. I've got my merge statement up a…

  ps_vbdev

  2 replies

  11 years, 3 months ago

  By: Lempster

• For a DW, is it worth always recompiling all SP's after weekly index maintenance?

  So not talking about SP's that run in a millisecond but procedures that run for up to an hour each.…

  rashid.hussain

  2 replies

  11 years, 3 months ago

  By: rashid.hussain

• Partitioned View Problem with my DW

  Hi All, I have been working over the last couple weeks with trying to implement a Partitioned View …

  skaggs.andrew

  8 replies

  11 years, 3 months ago

  By: skaggs.andrew

• Knowledge about Measurement

  Goal: Read more mesurement value from a business controller's perspective by using QlikView. Purpos…

  akirajt

  1 replies

  11 years, 3 months ago

  By: J Livingston SQL

• Should a DW track data origin system?

  Hi, we are in the beginning stages of designing our data warehouse. We have a lot of history (15+ y…

  Christopher Rannow

  7 replies

  11 years, 3 months ago

  By: herladygeekedness

• Questions about Budget etc.

  There are some questions I was wondering about. If you create a dashboard to display the value of a…

  akirajt

  1 replies

  11 years, 3 months ago

  By: Koen Verbeeck

• Recommendations on Project ReUse

  Hopefully I have this in the right forum. I'm asking this as a newcomer so forgive me if I say anyt…

  febagames

  1 replies

  11 years, 3 months ago

  By: Koen Verbeeck

• Is this part of product dimension

  Im building a product dimension of all the dresses designers can sell. each dress can have multiple…

  ps_vbdev

  6 replies

  11 years, 4 months ago

  By: Greg Edwards-268690

• Can you create a partition on an existing Fact table?

  Hi All, I have a Fact table that has been in use for 2 years now and I am getting to the point wher…

  skaggs.andrew

  12 replies

  11 years, 4 months ago

  By: skaggs.andrew