This session will look at ColumStore Indexes (introduced in SQL Server 2012) and Table Partitioning. Expect examples to be in evidence as we review each of the two technologies separately before combining them and examining how they can be used together to good effect. The benefits and pitfalls of each will be discussed as will the new xVelocity (VertiPaq) engine, since ColumnStore Indexes rely on this technology, also new in SQL Server 2012.
Andrew Whettam is a Consultant for Information Management Group and has previously led the Database and Business Intelligence teams for 3M and Capital One respectively. He works with both transactional and analytical databases and has modelled, designed and developed database systems across a variety of industry sectors. Recent IMGROUP projects have included roles as Data Modeller for a major financial institution and Data Architect for a large conglomerate. Past experience includes a number of high profile government projects. He has worked with all versions of SQL Server since SQL 7.0.