If I remember right, the BEST way to do the inserts is by inserting at the END of the index. So if your data is ordered by the clustered index,...

You say he won't be updating, but is it because he lacks permissions OR because he promised he wouldn't?

I would make sure your backups are good too. You do NOT...

Best guess - BigQuery is not expecting a column list in your CTE. BUT BigQuery is NOT the same thing as SQL Server 2022... You will likely get better results...

My opinion - if an end user is connecting to a DB using SSMS that isn't a DB Developer or DBA, they should only connect to the TEST system, not...

for question 1, I personally don't see the point. The windows event log has all that data, so why bother moving it to a new location PLUS you would need...

Another question - how many schedules do you have on the job right now? If you have more than 1, it could be that one of the other schedules is...

Are you expecting it to run today? if not, then set the start date to the date you want things to run.

To confirm, if you try to access SSRS via the web instead of your C# app, HTTPS is working correct? I would make sure that it is working from the...

With the new job, did you use the same start date? If so, may not hurt to bump the new start date up to the next expected run date.

Another question for you then - is it consistently FAST and SLOW if you run the same query in SSMS and the ERP OR is it only fast/slow in the...

So that is based on your start date. Jan 1st, 2015 + 26 months is March 1st, 2017. Next run is May 1st, 2019, then July 1st, 2021, then September...

• This reply was modified 2 years ago by Mr. Brian Gale. Reason: better solution provided by another poster

Are you really using SSRS 2005 or 2008? If so, I would recommend upgrading to a supported platform.

But, I wouldn't recommend adjusting the files manually when there is a GUI...

To add to what Grant said, are you using this in a stored procedure and passing that B700 and C900 as parameters? If so, then this could be a parameter...

Have you tried deleting the schedule and making a new one?

I've had schedules not behave the way I want (usually after doing in-place upgrades) and deleting the schedule and recreating...

Are you able to switch to simple recovery mode and do a backup? If so, that should put your log file down to 99% unused at which point you should...