I’ve uploaded my slide deck and scripts for my presentation Using Columnstore Indexes in SQL Server 2012 that I’ll be delivering at 11am in Colorado Springs tomorrow (January 7, 2011). To download the presentation material click here. If you’re undecided as to what sessions to attend this should give you a good idea as to what I’ll be talking about. When SQL Server 2012 is released, Columnstore Indexes will provide BI Architects and DBAs with another alternative for fast query response, but they are not appropriate for every situation. My session will give you a good understanding of when it’s right to use this feature and how to prepare your data models when the time comes.
Using Columnstore Indexes in SQL Server 2012
Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.
Click here for a blog I wrote last week with more details about my session. I’ll see you in the Springs!