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

Course Columnstore Indexes
Rating 4.6 of 37 users Rating 4.6 of 37 users (37)
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Book Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Programming in C#, Oxford University Press (c) 2014
Course Transactions
Rating 4.6 of 52 users Rating 4.6 of 52 users (52)
Course Triggers
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)