Partitioning Design for Performance and Maintainability
Partitioning your data allows a whole host of benefits to the performance and maintainability of your databases but still seems to be a dark art known only to a few people. With every release of SQL Server more features become available to help solve various problems and a lot of them require that your database has been partitioned for that feature to be used effectively. The most recent feature requiring partitioning is Column Store indexes, without partitioning you would be required to drop them before modifying any data in the base table and then recreating them from scratch.
Sorry, there are no downloads available for this session.
Martin Cairns, Senior BI Consultant (blog
). Martin is a consultant with Purple Frog Systems
a Business Intelligence & Data Warehousing Consultancy. He provides expertise for some of the UK's most prestigious clients including ASOS, AOL and Tesco. Martin has been working with SQL Server since 1998 and currently is specialising on data warehousing projects incorporating SQL Server and Analysis Services. With extensive experience designing and optimising multi-terabyte data warehouses, he particularly enjoys troubleshooting problems that occur at high scale, having successfully delivered a variety of BI projects across sectors including Banking, Insurance, Media and Retail. Passionate about the SQL community Martin can often be found sharing knowledge on the forums, on Twitter and is a regular face at community events.
The video is not available to view online.