Main Profile

At A Glance

Free SQL Server 2012 Training video - Pragmatic Works

Performance Tuning with Column Store Indexes Watch the full webinar here - http://tinyurl.com/pragwrks382 SQL Server columnstore indexes and the vector-based batch mode of query execution are new in the SQL Server 2012 release, and can speed up data warehouse queries by 100X or more. In their sweet spot, columnstores give jaw-dropping performance, but there are limitations in the initial release where performance may not improve as much as the technology allows, unless you tune your application. This talk presents how to work around the main limitations in the columnstore feature to get consistently great performance. We'll address how to compensate for query performance limitations for outer joins and union operations, data type restrictions, and the fact that columnstore indexes make the data read-only (except for the ability to switch in partitions). We'll also discuss how to capitalize on the new segment elimination feature that can skip million-row chunks of a table with a constant-time check. Making Business Intelligent - http://pragmaticworks.com/
Length: 07:46

Contact

Questions about Free SQL Server 2012 Training video - Pragmatic Works

Want more info about Free SQL Server 2012 Training video - Pragmatic Works? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question