<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Leo Peysakhovich
»
Data Distribution - Part 1
Data Distribution - Part 1
Rate Topic
Display Mode
Topic Options
Author
Message
Leo Peysakhovich
Leo Peysakhovich
Posted Saturday, July 24, 2010 8:08 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 6:18 AM
Points: 129,
Visits: 205
Comments posted to this topic are about the item
Data Distribution - Part 1
Post #958450
Phil Factor
Phil Factor
Posted Monday, July 26, 2010 8:13 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 4:00 AM
Points: 533,
Visits: 2,285
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
Post #958805
LP-181697
LP-181697
Posted Monday, July 26, 2010 8:33 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, January 30, 2012 5:12 AM
Points: 40,
Visits: 143
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.
Post #958822
SQLRNNR
SQLRNNR
Posted Monday, July 26, 2010 10:38 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #958910
Phil Factor
Phil Factor
Posted Monday, July 26, 2010 11:27 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 4:00 AM
Points: 533,
Visits: 2,285
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
Post #958940
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, July 26, 2010 12:07 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421,
Visits: 13,734
I'm not sure what happened, but I have added back the last code snippet and final para.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #958970
SQLRNNR
SQLRNNR
Posted Monday, July 26, 2010 12:11 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #958976
LP-181697
LP-181697
Posted Monday, July 26, 2010 12:13 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, January 30, 2012 5:12 AM
Points: 40,
Visits: 143
If text will not be edited with missed part, then I will add the missing part in comment tomorrow.
Post #958980
LP-181697
LP-181697
Posted Monday, July 26, 2010 12:14 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, January 30, 2012 5:12 AM
Points: 40,
Visits: 143
Thanks, now it has the sence.
Post #958982
LP-181697
LP-181697
Posted Monday, July 26, 2010 12:16 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, January 30, 2012 5:12 AM
Points: 40,
Visits: 143
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.
Post #958983
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
