1
kudos
spam Kudos Remove

SQL With A Plan : Large Scale DW/BI Design Considerations

published 1026 days, 13 hours, 8 minutes ago posted by sasa 1029 days, 14 hours, 16 minutes ago
Saturday, August 01, 2009 4:30:06 PM GMT Wednesday, July 29, 2009 3:21:48 PM GMT

One of the most challenging aspects of large scale data warehouse development is the sheer immense size.  It’s common to see all sorts of problems once the data warehouse gets larger.  Common problems include performance degradation, out of storage space, long running queries, blocking and failure to keep up with data feeds.   I have compiled a list of tips that help me to manage the size effectively over the years on terabyte DW projects.  I hope they will be beneficial to you as well.   Here we go: ...

category: Warehousing | clicked: 0 | | source: blogs.msdn.com | show counter code
tags: Batch, Fault Tolerance, Performance, Scalability

No comments yet, be the first one to post comment.

To post your comment please login or signup