I'm at a new place and working on several issues. One item that was passed to me was this proc that used to take a few seconds is now taking well over a minute or timing out.
The data hasn't changed too drastically.
filesReceived table has 902,596 records.
fileuploads table has 629,862 records.
We run SQL2016.
Can you see if there is anything I can do to help speed this back up?