Download Episode (mp3)

On this show, our topic is Partitioning.

We first talk about how we implemented Partitioning before SQL Server 2005 (or on Standard Edition).

After that, we talk about:

How to implement Partitioning

When it's right and wrong to use it

Will Partitioning help with query performance

How to make sure you leverage its benefits

Improvement Microsoft implemented over the years

Partitioning maintenance tactics

and much more..