Viewing 15 posts - 1 through 15 (of 18 total)
June 12, 2018 at 11:23 am
I had quite a bit of trouble with the files on github today. Doing save as gave me some html page content in the files (tried both IE and Chrome). ...
March 28, 2018 at 1:38 pm
This is a great article. Just FYI we skipped over 2012 for column store indexes since we didn't want to drop and rebuild the indexes as part...
February 25, 2015 at 7:44 am
The previous articles in the series describe why we can't use the truncate and reload scenario in detail. The short story is that this is a...
July 15, 2014 at 10:56 am
Jeff and N_Muller,
Thanks for your feedback. Jeff, we don't have an issue with downtime yet as we load the data in the off hours. However...
April 23, 2014 at 10:24 am
I always appreciate a better way to do things, so your suggestions are welcome.
I think we are basically "staging the full replacement" for customer 1 in the article you are...
April 23, 2014 at 6:19 am
We need to remove the data for the customer but don't want to incurr logging during deletes or inserts. We can't truncate because the other customers data must persist.
April 22, 2014 at 7:09 pm
It has taken on different forms internally over the years. The best I know its internally sourced from my employer's staff from ICF.
April 22, 2014 at 12:19 pm
I too have done projects where we had a master database that we synced the code and structures to the specific databases. We did this manual sync...
April 22, 2014 at 12:16 pm
Most of our fact tables take under 5 minutes to run. We have about 6 truncate and reload fact tables. Then the switch back into...
April 22, 2014 at 9:13 am
We have 2 more articles in the series done and in the publishing queue at SSC. We have planned 5 articles to cover most of our implementation highlights. ...
March 11, 2014 at 1:19 pm
Great work. I use the ManagePartition.exe found out on codePlex for this purpose. If you haven't seen it, it might be worth a read...
July 11, 2013 at 6:05 am
I agree with your comments on making yourself more valuable. Also, I can see how this is a tricky subject. My experience with multi-shoring has been...
July 29, 2010 at 6:39 am
Hey SQLFrenzy, great work.
We all should expect articles to be a good starting point and not a perfect solution. Your thought process is sound to me....
July 21, 2010 at 8:02 am
I think you meant, step A will not be run in one of your last paragraphs.
The article has
Execution time will be saved..."As it does not run the failed step"
January 14, 2009 at 8:35 am