GroupBy – Free SQL Server Training   /     An Introduction to Partitioning by DBAfromthecold

Subtitle
This mainly demo-based session will cover the following: An introduction to partitioning, core concepts, and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Considerations Splitting, Merging & Switching...
Duration
57:05
Publishing date
2018-10-23 10:00
Link
https://groupby.org/conference-session-abstracts/an-introduction-to-partitioning/
Contributors
Enclosures
http://traffic.libsyn.com/groupby/GroupBy069.mp3?dest-id=448922
audio/mpeg

Shownotes

This mainly demo-based session will cover the following:

  • An introduction to partitioning, core concepts, and benefits.
  • Choosing a Partitioning Key
  • Creating Partition Functions & Schemes
  • Indexing Considerations
  • Splitting, Merging & Switching Partitions
  • Implementing Partition Sliding Windows
  • Filegroup Restores with Partitioning

After the session, attendees will have an insight into partitioning and have a platform on which to be able to investigate further into implementing a partitioning solution in their own environment.