https://docs.microsoft.com/archive/blogs/sqlserverstorageengine/reduced-recompilations-for-workloads-using-temporary-tables-across-multiple-scopes