Monthly Meeting - May 2013
UTC : Thu, May 23 2013 18:00 - 19:00
Local Time: Thu, May 23 2013 18:00 - 19:00
Effective Index Partitioning, Compression Strategy
Neil Hambly, Database Administrator Confio Software
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 a 14-year SQL Server veteran, with expertise in SQL Server from version 6.5 to the latest 2012 edition. He's held database roles at major organizations, including the BBC, ABN AMRO, and Accenture, as well as at a number of market-leading companies. Currently a senior DBA at Confio Software, he’s worked as a DBA, developer, and architect. Leader of the PASS London Chapter, Neil can frequently be found speaking at UK and international events.