call us toll-free +1 855 855 3600
 
Home > Videos > Webinar – Kalen Delaney’s SQL Server Webinars – Episode 8

Webinar – Kalen Delaney’s SQL Server Webinars – Episode 8

 

Author: Kalen Delaney

Event date: 11/21/2017

 

We’re continuing the discussion of Physical Storage with Part 5 of this topic.

In this installment, Kalen will tell you about Nonclustered Index storage, using examples from SQL Server 2016 and SQL Server 2017.

Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well.

Specific topics include:

  • Heaps vs B-Trees review
  • Nonclustered index leaf level
  • Nonclustered index upper levels
  • What is the key column
  • Composite indexes
  • Covering indexes
  • Other nonclustered index options

For those who miss the live webinar, we have a recording for free! We’d just like to know a little bit about you, and you’ll get access to the webinar recording.