We’re seeing tempdb DB spills for some hashing operations. If the estimates are indeed good as shown what would be the next thing(s) to look for? Looking for a generic answer without having to resort to the specifc query.
This is part of an SP. Just switched to 2019 version to see if it would auto adjust but still getting spills so far.
Microsoft SQL Server 2019 (RTM) – 15.0.2000.5 (X64)
Go to Source