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..