Nonclustered, In-Memory, & XML Indexes

SQL Server 2016    |    Intermediate
  • 9 videos | 42m 6s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Explore columnstore performance considerations that can impact operations, nonclustered indexes, in-memory indexes, and XML indexes.

WHAT YOU WILL LEARN

  • Create a nonclustered columnstore index
    Change data in a nonclustered columnstore index
    Describe in-memory nonclustered hash indexes
    Create tables with nonclustered hash indexes
    Describe in-memory index performance considerations
  • Describe xml indexes
    Describe secondary xml indexes
    Describe xml index performance considerations
    Implement and configure columnstore indexes

IN THIS COURSE

  • 5m 16s
    In this video, you will learn how to create a non-clustered column store index. FREE ACCESS
  • 4m 8s
    During this video, you will learn how to change data in a non-clustered column store index. FREE ACCESS
  • Locked
    3.  Changing Data in a Nonclustered Columnstore Index
    3m 37s
    Upon completion of this video, you will be able to describe nonclustered hash indexes that are stored in memory. FREE ACCESS
  • Locked
    4.  In-memory Nonclustered Hash Indexes
    7m 44s
    Learn how to create tables with nonclustered hash indexes. FREE ACCESS
  • Locked
    5.  Creating Tables with Nonclustered Hash Indexes
    6m 57s
    Upon completion of this video, you will be able to describe performance considerations for in-memory indexes. FREE ACCESS
  • Locked
    6.  Performance Considerations
    4m 32s
    Upon completion of this video, you will be able to describe XML indexes. FREE ACCESS
  • Locked
    7.  XML Indexes
    3m 55s
    After completing this video, you will be able to describe secondary XML indexes. FREE ACCESS
  • Locked
    8.  Secondary XML Indexes
    2m 20s
    Upon completion of this video, you will be able to describe XML index performance considerations. FREE ACCESS
  • Locked
    9.  Performance Considerations
    3m 37s
    Find out how to implement and configure column store indexes. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Triggers
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Course Keeping Business Calls Professional
Rating 4.6 of 3767 users Rating 4.6 of 3767 users (3767)