Not certain this is the correct place for this, but why is the NodeID on this semi-critical table of a different datatype than every other table I checked where it's flagged as a uniqueidentifier type?
I suppose I can select a subset of this massive table into another table or come up with some severely arcane SQL CAST statement, but it's somewhat cumbersome to join it to even Nodes using anything more than the most rudimentary queries.