Data Distribution - Part 1

  • Comments posted to this topic are about the item Data Distribution - Part 1

  • I'm not clear to me whether you are suggesting that this approach (restore followed by a rename) is a good way of updating the data marts from the hub. If so, then it would need some more explanation, as I'm still wondering whether you are suggesting it over more elegant solutions just because of huge volumes of data to be transferred. Apologies if I've misunderstood.

    Best wishes,
    Phil Factor
    Simple Talk

  • Phil Factor (7/26/2010)


    I'm not clear to me whether you are suggesting that this approach (restore followed by a rename) is a good way of updating the data marts from the hub. If so, then it would need some more explanation, as I'm still wondering whether you are suggesting it over more elegant solutions just because of huge volumes of data to be transferred. Apologies if I've misunderstood.

    Unfortunately, the last part of the article is missed and this is created misunderstanding. Even for me is difficult to understand myself. I did sent email to the publisher but has no response. You are right. For the small data warehouses (up to 10G) it is one of the ways to replace data and make very short period of data inavalability. We preparing data in separate data warehouse, loading it to every server from HUB and then switching within 1 second or even less. We have 3-4 data warehouses and doing this for at least 2 years during low nightly traffic. Our data warehouses supporting many applications. What we got with this process 1. data updated on all servers practically at the same time. 2. Data availability 24*7 3. Ability load and verify data first before it get used 4. Data integrity at any time - there is no time when data inconsistent because of load process.

  • Thanks for the time taken to write this article.

    I too would have liked to see something more verbose in the explanations. More detail would also be good.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Unfortunately, the last part of the article is missed and this is created misunderstanding. Even for me is difficult to understand myself. I did sent email to the publisher but has no response. You are right. For the small data warehouses (up to 10G) it is one of the ways to replace data and make very short period of data inavalability.

    Ah, I understand now. It will be interesting to see the second part then. It is an interesting topic and great to see what is involved with providing a working solution for this sort of warehousing. Thanks for the article.

    Best wishes,
    Phil Factor
    Simple Talk

  • I'm not sure what happened, but I have added back the last code snippet and final para.

  • Steve Jones - Editor (7/26/2010)


    I'm not sure what happened, but I have added back the last code snippet and final para.

    Thanks Steve.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • If text will not be edited with missed part, then I will add the missing part in comment tomorrow.

  • Thanks, now it has the sence.

  • Steve Jones - Editor (7/26/2010)


    I'm not sure what happened, but I have added back the last code snippet and final para.

    Thanks, Steve.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply