David Peter Hansen
David Peter Hansen is a BI Technical Solution Lead at Maersk Line, the world largest shipping company. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He specialises in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions.
“Just use partitioning” is the answer you hear, when you need to manage very large data sets in your Data Warehouse. But how do you design and implement it? We will walk through different ways to design partitioning, including layered partitioning.
Blog posts
|
Manage very large data sets Loading and managing large data sets in your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data.… Read more ›
|
|
Here is a few links to articles, white papers, and best practices on partitioning on Microsoft SQL Server. I have these at the end of my slide deck on layered partitioning, which uses a combination of partitioned tables and a partitioned… Read more ›
|
|
This query is quite useful when looking at which partitions are in the database. It is originally taken from the book Microsoft SQL Server 2008 Internals (p. 438), and then I have tweaked it a bit and added some more information.… Read more ›
|