The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Nov 20 2018 17:00 UTC


An Introduction to Partitioning

RSVP: None

An Introduction to Partitioning

Are you a Database Administrator or Developer who has not previously implemented partitioning within an OLTP database? Have you thought about it, want to implement it, or even been asked to? We're going to go over the concepts and implementation of partitioning for you! We'll cover: • Introduction to partitioning, core concepts, and benefits. • Overview of partitioning functions and schemes. • Considerations for selecting a partitioning column. • Creating a partitioned table. • Explanation of aligned and non-aligned indexes. • Manually switching a partition. • Manually merging a partition. • Manually splitting a partition. • Demo on partition implementation & maintenance, covering automatic sliding windows. A SQL Server DBA, originally from Swansea, Wales but is currently living in Dublin, Ireland, Andrew has been working with relational databases (in one form or another) for over 10 years and has been a SQL Server DBA for 6 of those.


SQL Server DBA with over 10 year's experience. Originally from Wales but now living in Ireland

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids