阅读背景:

在数据仓库方案中使用WITH(NOLOCK)有任何不利之处

来源:互联网 

I have a Kimball-style DW (facts and dimensions in star models - no late-arriving facts rows or columns, no columns changing in dimensions except expiry as part of Type 2 slowly changing dimensions) with heavy daily processing to insert and update rows (on new dates) and monthly and daily reporting processes. The fact tables are partitioned by the dates for easy rolloff of old data.I have a Kimball-style DW (facts and dimensions




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: