Compression - Define your Strategy
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one - we will be using compression estimates along with index usage information, fill-factors to achieve a balanced strategy
This session will not only cover the core principles of SQL Server's data compression feature, how it functions, what options you can choose, and how it performs under differing workloads.
We will also look at how to integrate data compression into your current schema designs and the challenges you will likely encounter, examining the all-important performance aspects and the configuration changes to consider along with SKU editions requirements.
Sorry, there are no downloads available for this session.
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
The video is not available to view online.