Dealing with billion rows tables in SQL Server is challenging. Resolving performance issues when working with them is not easy either. Sometimes we consider implementing table partitioning to try to deal with large tables issues. But table partitioning, just the same as indexing, is not a silver bullet. There are few important things we need to consider before implementing partitioning. In this demo-rich session we will cover these key points. We will understand how the partitioning works and how it helps for better data management and maintenance. When do we get improvement in the performance, and when should we better not choose partitioning but some other optimization techniques instead. Shall we divide our large tables in partitions, or we could just create yet another index to improve query response time? These are just some of the questions you will find answers in this session.