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). ...

Hugo,

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...

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...

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...

Jeff,

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...

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.

It has taken on different forms internally over the years. The best I know its internally sourced from my employer's staff from ICF.

Hey David,

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...

Hello,

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...

Peter,

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. ...

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...

Steve,

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...

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....

Nice article.

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"

Thanks,

Sean