Effective Indexing with Partitioning and Compression

We all know that correct indexing is king when it comes to achieving high levels of performance in SQL Server. When indexing combines with the enterprise features partitioning and compression, you can find substantial performance gains.

In this session, use scripts to query dynamic management views (DMVs) to identify the right objects on which to implement strategy, measure performance gains, and identify the impact on memory and other resources. Devise a sliding-window, data-loading strategy by using partition switching. Track fragmentation at the partition level and minimize index maintenance windows. Discover partitioning improvements in SQL Server 2014. Take home an advanced script for tracking usage and details on fragmentation, memory caching, compression levels, and partitioned objects.