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 Microsoft Certified Master (MCM) and has over a decade of experience with database development and administration on SQL Server and the Microsoft Business Intelligence platform. Today, he works as Senior Premier Field Engineer at Microsoft. He specializes in delivering training as well as scalable architecture and performance tuning on large-scale data platform solutions. He is a frequent speaker at conferences, and have given talks in Europe, USA, and South Africa.