There are features of SQL Server I use often and consider to understand reasonably well, features I know but rarely use, and probably a whole list of things I’ve only looked at or used once. Within the realm of things I know, sometimes I find that I had an incomplete understanding or missed a dark corner because I never needed to explore it. While chagrin or the Picard facepalm are natural reactions to “I thought I knew that”, better to appreciate that I now have one less gap in my game than before. In this case, as you’ve probably surmised,
