BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20130504T071000Z DTEND:20130504T081000Z LOCATION:SQLBits Conference - Theatre SUMMARY:Layered Partitioning - manage very large data sets DESCRIPTION: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. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning.  X-ALT-DESC;FMTTYPE=text/html:

Layered Partitioning - 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. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. 

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.

http://dave.dk/ UID:SQLBITS1509SEQUENCE:0 DTSTAMP:20130523T132944Z END:VEVENT END:VCALENDAR