Slow SQL Server view that consumes massive amounts of tempdb space
We've noticed a view running in our LanSweeper database that regularly runs several times a day that takes about 25 minutes to complete and consumes upwards of 200GB in tempdb during its run-cycle. SELECT COUNT(1) AS total FROM web50rep6ba596c64f8b45...