Table Partitioning in SQL Server Brandon Leach | DBA for SurveyMonkey, SQL Server Professional, Co-Organizer for the New England SQL User's Group, and Speaker

City of Calabasas Library 200 Civic Center Way Calabasas, CA 91302

November 19th, 6:30 pm

Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you! Partitioning allows us to break a table or index down into smaller more manageable chunks. It can enable us to perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations. In this 75 minute session we’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning effects things under the hood to solidify our understanding of how it works. At the end of this session you’ll have a firm understanding of partitioning and be armed with the knowledge needed to make decisions on how and when to implement. About Brandon: Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he quickly fell in love with SQL Server database development and administration. Currently he is a senior DBA for SurveyMonkey. He works closely with the development, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.