As promised here is a short video to start of the series on SQL Server partitioning. The video covers the difference between simply placing files in Filegroups with multiple files and partitioning. It also touches upon the effects of proportional filing and its impact on IO throughput. More importantly it explains when to use what.
In the next video I am going to cover how to implement partitioning, as well as multiple file groups and files.
In the last video I will cover how to convert existing tables into Partitioned tables and the sliding windows scenario.
Those who have suffered through each of the videos will have an in-depth knowledge of how partitioning works in MS SQL Server.
PS: – As always I would love to hear anything you have to say on the videos. Please be ruthless if you have to: D