4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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.
Presented by Neil Hambly at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 755 KB
    Video available MP4 Video HD 517 MB
  • SpeakerBIO
    neil_hambly.png

    Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect, 

    He is a SQL Server Technology Evangelist @ Northdoor PLC www.northdoor.co.uk

    The Leader of both the PASS London and Virtual Professional Development Chapters

    Neil is often found presenting @ international and domestic SQL events

    http://sqlblogcasts.com/blogs/NeilHambly
  • Video