Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains. Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect. Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Neil Hambly is the SQL Server Evangelist & lead consultant @ Northdoor PLC (MSFT Data Platform Gold partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 15+ years in SQL Server roles
Presented 120+ events, including 50 PASS Summit/24HOP/Rally/SQL Saturday, 20 European events (12 countries), 50 + UK (SQLBits, SQLRelay)
Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015)
SQL Cruise Technical Lead, Likes Guinness, Loves Whisky, Dancing