Thanks. I carried out a full index rebuild and updated statistics for the main database on the server and that seems to have helped the issue a bit. During Christmas...
Yes - the job has gone from 4 - 10 hours (there are number of update queries called via a stored procedure). Queries that normally completed in a short period...
We have overnight jobs on this server that update a data warehouse. I noticed the job time had jumped from around 4 hours to 10 hours without anything changing as...