guys, I have a stored procedure that is part of a job that usually takes 30 mins to run tops. The last couple of nights that job has exploded to 6 hours. I currently have the job running in SQL and I confirmed that all the tables have data. We are truncating and inserting into the table. Not sure what is the best way to troubleshoot this one.
I also ran the code without the insert into and truncate ( just included the declares) and I got some data back ( I just ran it for a few minutes to make sure I was getting at least some data back.
any ideas on where to start?