PASS Summit 2016: Where Data Professionals Connect, Share & Learn
Blog Post
Demo: Accelerating Data Warehouse Queries with SQL Server 2012 Columnstore Indexes
Play Demo: Accelerating Data Warehouse Queries with SQL Server 2012 Columnstore Indexes
Description
This demonstration shows how to implement Columnstore Indexes, establish the performance impact for a standard data warehouse query and lastly show how to modify rows for a table with a Columnstore Index using partitioning.
Joe Sack
Principal Consultant, SQLskills
Download
Right click or Alt+Enter to download this episode
- MP3 (8.3 MB)
- Low Quality MP4 (50.4 MB)
- Mid Quality WMV (23.0 MB)
- High Quality MP4 (110.6 MB)
- Mid Quality MP4 (77.4 MB)
- High Quality WMV (54.6 MB)
The Discussion
-
rdoherty Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Related episodes
At least $10,000 savings on SQL Server clustering in Microsoft Azure
Presentation: Introducing SQL Server 2012 AlwaysOn Failover Clustering
Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering
Presentation: Introducing SQL Server 2012 Columnstore Indexes
Demo: Maximizing Hardware Utilization with SQL Server 2012 AlwaysOn Active Secondary…
Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas
Presentation: Introducing SQL Server 2012 Table Partitioning Improvements
Demo: Table Partitioning in SQL Server 2012
Presentation: Introducing SQL Server 2012 Security and Auditing Improvements
