Table Partitioning Deep Dive

From zero to hero, understand table partitioning now and forever! Partitioning is not a silver bullet of our biggest tables! Many thinks can go wrong. Before we consider it, we need to understand how it works. In this demo-rich session we will cover all you need to know about it. We will start from introducing the table partitioning and will dive very fast into mastering it. We will cover partition elimination, aligned and non-aligned indexes. We will pay special attention on choosing the partition key, reading query plans of partitioned tables, and troubleshooting performance problems. At the end of this deep dive session, you will get a very good understanding of how the partitioning works and how it helps for better data management and maintenance. On top of technical demos, I will give you examples from many real cases I’ve gone through. You will get ideas on how to approach more complex cases of historical data maintenance, by combining partitioning, indexing, and records deletion. You will know how to achieve performance improvement, and when you should not choose partitioning but some other optimization techniques instead.