Topic:
Struggling to cope with extremely large tables? Is performance tuning a nightmare? Struggling to delete old data?
The solution you’re looking for could be Partitioning. Properly introduced to SQL Server with 2005, and available in all editions since SQL Server 2016 Service Pack 1, partitioning allows you to split your tables into manageable chunks without having to rebuild your code and applications
In this session, I’ll take you through the benefits of partitioning, implementation best practices, pitfalls to avoid, and strategies you can take away to use.
Speaker:
Stuart Moore – Data Wrangler
Stuart has been working with data since 1998 across a wide range of platforms Currently building and designing hybrid solutions tying on-premise and cloud systems together
Stuart is a major contributor to the dbatools project and other open source projects, he also runs 2 user groups (East Midlands SQL Server group and Nottingham PowerShell Usergroup) and is a member of the team that runs the annual SQL Relay series of 5 one day conferences around the UK. Was given the Data Platform MVP award by Microsoft in 2018.