While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...

How many missing index requests are in the execution plan...

Hold the phone a minute... why do you have two tables that you must maintain the name in?  That's not "normalization" and having to do such maintenance is contrary to...

The point of the...

Just remember that "all relationships" are normally based on the presence of FKs.  A whole lot of 3rd party vendors don't even know how to spell "FK".  I've not worked...

Please see the following articles.
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
Hierarchies on Steroids #2: A Replacement for...

I don't have access to a 2016 box just now but I believe this can be done using Lead or Lag. I believe that Books Online has an example.

@jonathan-2,

Nice function.  It seems like you've included just about every optimization for rejecting non-prime candidates there is.

Funny you should bring this up...

I'm working on (but have not yet completed) a method to determine which index/heap the last page of an MDF file maps to,...

Just a thought...

This reminds me of the Factorial function.  The same values will always be returned.  With that in mind, it would probably be the best to store...