This talk covers the new columnstore feature in SQL Server 2012, which drastically improves performance for data warehouse queries. I’ll take the feature apart to not only discuss the layout of these indexes, but also their optimization with batch mode processing inside the query itself. I’ll also discuss additional query plan improvements and new query iterators and query plan warnings in SQL Server 2012.
- Build a Microsoft private cloud using free trial software
- Review licensing and purchasing options
- Watch the Jump Start "Creating and Managing a Private Cloud on System Center 2012"
- Learn more about Microsoft’s private cloud strategy
- Review your options for training on the cloud
- Try Microsoft private cloud
- Try System Center 2012 software