PASS Meeting: Partitioned Tables & Query Performance

  • Date: Monday, July 31, 2017
  • Time: 5:45PM
  • Duration: 2 hours
Michiana SQL PASS Chapter

Speaker: Jay Robinson, Senior Systems Engineer at Sales Force

Jay Robinson earned his MCSD and MCSE in 1999, getting certified on SQL Server 6.5 and 2000 along the way. A nice and quiet career as a developer followed. Then he came to ExactTarget (now the Salesforce Marketing Cloud) in 2008 and found out what real databases were like. Obsessed with speed, he spends his time writing code that makes big data go fast.

What he will cover: Partitioned tables are an ideal solution for improving write performance in certain situations. But they present unique challenges for the developer who simply needs to query the data. In this session, you will learn how the optimizer takes partitioned tables into account when producing query plans, recognize common query plan issues, and learn tactics for improving performance when querying partitioned data.

Where: Harmony Healthcare IT, 53702 Generations Drive, South Bend, IN 46635