There are many benefits of partitioning large tables in SQL Server. You can speed up loading and archiving of data, you can perform maintenance operations on individual partitions instead of the whole table, and you may be able to improve query performance. However, implementing table partitioning is not a trivial task and can actually cause worse performance if it is not done correctly. In this session Cathrine will walk you through how we implemented table partitioning in our Data Warehouse - and how to re-implemented table partitioning after realizing just how many mistakes were made the first time. Learn how to choose an appropriate partition key, how to create partition functions and partition schemes, and how to write queries that take advantage of partition elimination. You will also learn about partition maintenance and the sliding windows technique for efficiently loading and archiving data.