I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City

Meeting Details

Tuesday,

July

08

Divide and Conquer – Creating and Managing Partitioned Tables and Indexes in SQL Server

  • In-Person @ 1850 Boyson Rd, Hiawatha, Iowa (map)
  • Tue, Jul 08 2014
    17:30 - 19:30 Central Daylight Time
  • Language: English

Featured Presentation:

Divide and Conquer – Creating and Managing Partitioned Tables and Indexes in SQL Server

Russ Allen, SQL Server DBA/BI Developer University of Iowa

This presentation will provide an overview of table and index partitioning in SQL Server 2012 and 2014, and describe a step-by-step approach for creating and managing partitions in a large data warehouse. Topics will include:

  • The benefits of table and index partitioning
  • Partitioning requirements and considerations
  • Laying the partitioning foundation
  • Creating partitioned tables and indexes
  • Adding data one partition at a time
  • Removing partitions when their data has “aged out”
  • Piecemeal restores of partitioned databases

The presentation will include a live demonstration of partitioning using fact tables from the AdventureWorksDW2012 sample database. All scripts used in the demonstration will be available to attendees after the presentation.

About Russ:
Russ Allen has over 30 years of experience as a developer, technical instructor, and database administrator. He has worked for a variety of Eastern Iowa employers including Norand Corporation, Parsons Technology, Entre Information Systems, Productivity Point International, and Mercy Medical Center. For the last eight years, Russ has been a SQL Server DBA and BI Developer for the University of Iowa.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids