SQL Server Columnstore Performance Tuning

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Slides (view online)
Columnstore indexes, and a new, vector-based query execution method called “batch mode,” can speed up query processing in data warehouses and data marts using Microsoft SQL Server 2012 by a breathtaking 10X to 100X. This talk describes how to tune indexes, queries, and load processes to help your customers get the most out of columnstore indexes and query execution. Learn secrets that can help you turn modest performance gains into stunning, orders-of-magnitude improvements, and blow away the competition. We focus on how to work around constraints that limit the use of batch processing when outer joins, unions, and certain other constructs are present in queries. We also describe how to load columnstores effectively, and even perform real-time loads on columnstore indexes that are technically read-only. #TEDBI409

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

Event Homepage

TechEd North America 2012

More sessions in this event

See More

Related sessions

Creative Commons License

© 2013 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.