Chicago Data Professionals May 11th Meeting

This will be a Virtual Event Only

To Attend Online Click on Link Below:
Attend Online

# Treating Tables Like Legos: Partitioning basics

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!

With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations.

We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll also look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement.

At the end of this session you’ll have a firm understanding of how partitioning works and be able to make decisions on how and when to partition.

You'll learn…
• The components of table partitioning and how they fit together • How to make your index maintenance partition aware
• How Partition elimination can help your queries
• How to split different parts of tables over different storage tiers • How to manage partitions. We'll demo this by implementing the sliding window technique.

# Brandon Leach Bio

A Microsoft Data Platform MVP, Brandon is a senior member of the Database team for financial company x functioning as a SQL Server Infrastructure Architect/SME. Having worked in data estates of several petabytes across thousands of servers, he puts a high focus on performance tuning and automation at scale. He is a frequent speaker at events like conferences and user groups.

5:45 to 6:00 PM
Members can ask questions, do networking, discuss SQL Server related issues currently facing, and get advice from the chapter leaders and from other members. Also, report if you have job openings or looking for a job.
6:00 to 7:00 PM
The feature presentation of the day
7:00 to 7:30 PM
Members can ask questions of the speaker and network with each other.