About the Presentation
Loading Data In Real Time
After an overview of partitioning and how to set up partition functions & schemes we'll take a look at how to load data and instantly switch it into production without significant impact to your database availability. Topics covered: Partition Functions & Schemes, Creating partitioned tables, The $partition function, Switch Statement and system tables for viewing partition information
Session Level: Intermediate
Mike Femenella
Mike has been a SQL Server Developer and DBA for the last 12 years. He's written several articles for SQLTeam.com and conducts training sessions on various SQL Server subjects for developers at Bank of America.
Contact URL: