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.
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Neil Hambly is a Senior DBA @ Confio Software, having held various SQL Server roles during the last 14 years @ market leading companies (Accenture, ABN AMRO, BBC, iProfile, MDSL)
He has considerable Experience in SQL Server starting with version 6.5 through to the latest 2012 release. A regular International speaker @ SQL conference & User Group, he also leads the SQL London PASS Chapter (UK). Frequently found studying the inner workings of SQL Server, as well as an avid Tweeter @Neil_Hambly.
- Video
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.