Table Partitioning Intro and make that a sliding window too!

Speaker(s)Jeff Reinhard 

Duration: 60 minutes

Track: Enterprise Database Administration & Deployment

I walk-through the entire process of discovering a situation that would benefit from a partitioned table, designing the partition key and scheme, and implementation. Then also creating a sliding window partition, both adding new partitions and rolling out older ones, all on an AdventureWorks table, so that all the scripts can be used by participants later for practicing.