SQL Server Table Partitioning with Dan Guzman 06-13-2023

Content:
SQL Server table and index partitioning improves manageability of very large tables and facilitates nearly instantaneous load/purge/archive processes with partition-level operations. However, table partitioning may also introduce query performance regression when not used wisely. This session reviews table partitioning architecture, strategies, best practices, common gotchas, and mistakes.
Dan Guzman
Dan's been using SQL Server since version 4.21 was introduced on Windows NT and has over 30 years of database administration, development, and architect roles. He answers questions on StackOverflow, StackExchange, and Microsoft Q&A forums, speaks at user group meetings and conferences on database topics, and has received 18 Microsoft Data Platform MVP awards since 2001.

[@TristramCox]

Fantastic and informative, was able to achieve something I've been scratching my head over with your help, many thanks