SQLBits 2020

SQL Server Table partitioning – DOs and DON’Ts

When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?

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.