319 Mar 2012 @ 02:16 PDTMarcio MouraLet's talk about Surrogate Key GenerationGreatly enjoyed this one, Marcio! Keep up the good work! @Shiv_Giri, based on my understanding of the post, I don't believe the surrogate key tables that Marcio is talking about are meant to be ...
217 May 2010 @ 10:19 PDTMarcio MouraLet's talk about Multilevel Partitioned Primary Indexes (MLPPI)Very slick way to begin implementing a near real-time datawarehouse. What is the impact on the reporting queries while these half hour loads are going on--especially during work hours?
128 Dec 2009 @ 06:06 PSTMarcio MouraWhen is the right time to refresh statistics? - Part IGreat article, Marcio!! Looking forward to the techniques in automation of the statistics collection process. Cheers!