This will return the top 5 populous countries sorted in DESC order, followed by the top 5 States/Provinces (in the world) in the same DESC order.

SELECT [measures].[population] on...

I'm getting a strange result from the following. Any clues as to why?

{[Date].[Calendar].[Calendar Quarter].[Q1 CY 2007].firstsibling}

Returns itself, Q1 CY 2007 (ok I understand that)

{[Date].[Calendar].[Calendar Quarter].[Q2 CY 2007].firstsibling}

Returns Q1...

I'm going to leave this right here, even though I think it might just get answered in the next Stairway article.

In the example from STEP 3, how could I sort...

This error popped up for me just a minute ago as well. All I did to fix it was change the DelayValidation to True on the connection manager AND...

Just came here to say that I too use the prefixes of fact_ , dim_ and stg_ for my tables. I've played around with using schema's as a form...

+1 for Kimball SCD. However, there are times when you can still use the standard SCD component that is default in SSIS. For example if your dimension table...

I came here to suggest Robocopy as well. We've used it before when moving large mdf files from what drive to another. I use a Execute Process...

Daniel Bowlin (12/9/2010)

---

I would suggest that at least for order status you should use a Type 1 SCD. In other words, just update the original record in your order...

I would populate the FACT table with only those accounts whose status in the dimension has a Start_Date and an End_Date (Effective date and Expiry). With those two dates...

I use a current record column which I call is_current. 1 = TRUE, 0 = FALSE. If I wanted to see the order in which that particular records'...

Have you considered creating your own sp that will reindex only certain tables on a specified day? In other words, reindex your tables in batches, which are run on...

Hello Greg. I do know of a way to do both things that you are asking, but my answer will be based on a few assumptions

1) It is not...