When we look at sessions being blocked in SQL Server, the session most often causing the blocking is a Session ID (SPID). However, there are some occasions where the SPID doesn't make any sense.

Microsoft today released SQL Server 2022, the latest version of its database software, ... which can now optimize queries in a number of more complex scenarios, for example.