Dealing with billion rows tables
in SQL Server could be challenging. Resolving performance issues when working
with them as well. 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 what the partitioning main purpose is and
how it helps for better data management and maintenance. When do we get
improvement in the performance, and when should we better not choosing
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.