Which SQL table statistics are used after they are updated when NORECOMPUTE is turned on?
According to this:
https://docs.microsoft.com/en-us/sql/relational-databases/query-processing-architecture-guide?view=sql-server-2017#recompiling-execution-plans
ALTER TABLE and UPDATE STATISTICS commands trigger execution plan recompilation. So seems like the new statistics would be used by all queries executing after either of those procedures.