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

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.

Nonclustered Index

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.

Tell us a little about you first

Privacy policy

RELATED RESOURCES

14
Dec
Best Practices Migrating Oracle Databases to SQL Server

DB Best's principal solutions architect Rick Heiges delivered a webinar on migrating Oracle to SQL Server. Rick covered the following topics: Migration process and tools Data deployment Cloud migration Tool support Many Oracle customers are concerned about being locked into a single vendor with high licensing costs. There is ...

26
Sep
Snack Bite: Top 3 reasons to run SQL Server 2017 on Linux

In this 9-minute snack bite video, Bill Ramos talks about the top three reasons why you’d want to consider moving from existing versions of SQL Server running on the Windows platform to SQL Server 2017 on Linux....