Big Boys Toys
This session will look at ColumnStore 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 features introduced in SQL Server 2014.
Sorry, there are no downloads available for this session.
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.
The video is not available to view online.