When you start this course, you will develop an understanding of the architecture of tables and indexes within SQL 2014. You will review how they have changed to accommodate partitioning and understand the tools you will need to move forward. You will go over partition boundaries and the practice of mapping partitions to file groups as well as the creation of partition tables.
After reviewing the basic creation of partitions, you will then develop an understanding of querying and managing partitions. You will address complex querying as well as correlated subqueries, where they are used, how they affect performance, and the appropriate times to replace them. We will then explore complex data, structures, and identify how we can implement efficient queries.
Lastly, we will be covering XML Data Type and the steps needed to ensure performance gains, with the proper use of XML indexes on XML columns. We will use this knowledge to address XML schemas, querying, and review the best practices when implementing partitions in SQL 2014.