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 very much of what do you need to know about it. In the Part 1 of this 100 min session we will start from table partitioning mechanics and will dive very fast into mastering it. We will cover partition elimination, aligned and non-aligned indexes. In the Part 2 we will pay special attention on choosing the partition key, will touch a bit 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.