Microsoft Business Intelligence and Big Data User Group of New York City presents: SQL Server 2012 Columnstore index – What it means for Data Warehouse and Business Intelligence Applications
Monday, November 12, 2012 from 6:00 PM to 8:30 PM (EST)
SQL Server 2012 Columnstore index – What it means for Data Warehouse and Business Intelligence Applications
It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well. Finally, I’ll talk about the new xVelocity (formerly “Vertipaq”) engine in Analysis Services 2012, its relationship to the Columnstore index, and the benefits.
Presenter: Kevin S. Goff
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the Mid-Atlantic region.
Contact URL: http://www.KevinSGoff.net
11-12-2012 6:00 P.M. – 8:30 P.M.
Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104
When & Where
Microsoft Business Intelligence and Big Data User Group of New York City
A community dedicated to the development of expertise in Microsoft BI technologies and related third party products.