Platinum Sponsor

Effective Index Partitioning & Compression Strategies

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 Enterprize 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 XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • 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 now the Principle Database Engineer @ ASOS. He is a PASS UK Regional Mentor & leader of SQL London PASS Chapter, often seen speaking @ international and national SQL events
    http://sqlblogcasts.com/blogs/NeilHambly
  • Video
    The video is not available to view online.