Andrew Pruski
dbafromthecold.com
SQL Server DBA originally from Wales but now exploring Ireland.
Blogging at dbafromthecold.com and has spoken at multiple events in Europe and the US.
SQLBits 2018
Introduction to partitioning
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Session will cover the following:-
An introduction to partitioning, core concepts and benefits.
Overview of partitioning functions & 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.
After the session, attendees will have an insight into partitioning and have a platform on which to be able to investigate further into implementing partitioning in their own environment.
Session will cover the following:-
An introduction to partitioning, core concepts and benefits.
Overview of partitioning functions & 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.
After the session, attendees will have an insight into partitioning and have a platform on which to be able to investigate further into implementing partitioning in their own environment.