boundary-points

SPLIT in a LEFT Partition Function: Where Does the Above-Boundary Data Go?

SPLIT in a LEFT Partition Function: Where Does the Above-Boundary Data Go?

Table partitioning seems simple, but there’s a lot of complexity in designing and managing it if you decide to use filegroups and splitting.

When you first implement partitioning in this scenario, you decide where you’re going to keep “out of bound” data when you create your partition scheme. Be careful when you make that decision, because it may not be easy to change later.

Sliding Window Table Partitioning: What to Decide Before You Automate

Sliding Window Table Partitioning: What to Decide Before You Automate

Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn’t necessarily mean that partitioning will make queries faster.
How to Fix Lopsided Partitioned Tables

How to Fix Lopsided Partitioned Tables

Over the years I’ve gotten lots of emails and questions from students that start like this:

Help! My partitioned table has the wrong data in a partition! It’s lopsided. I started trying to fix it, but…