Rick Heiges Principal Solutions Architect, DB Best Technologies, LLC Rick Heiges is a Data Platform MVP and Principal Solutions Architect for DB Best Technologies LLC – http://www.dbbest.com. He works with customers educating them about the Microsoft Data Platform to solve business problems and to maximize the value of their data. Rick is very involved in the SQL Server Community via PASS where he spent 9 years on the Board of Directors.
Follow Rick on Twitter:
https://twitter.com/@heigesr2 You can read his blog on:
http://sqlblog.com/blogs/rick_heiges/
|
Winning with Columnstore: a Customer Story This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Columnstore for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and columnstore) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now. |