Are you sure your data system really needs it all in actual columns? ( advocate of the devil, I know )

Have you considered putting those "free wheeling columns" into an...

It is indeed a concept that uses tempdb to get it things done. ( versionstore )

The difference between both:

- 'snapshot isolation level" is a transaction setting  ( which has to...

• This reply was modified 5 years, 6 months ago by Johan Bijnens.
• This reply was modified 5 years, 6 months ago by Johan Bijnens.

please read MS docs about tempdb database

This is where you want to be starting when taking tempdb into focus: Tempdb configuration survey results and advice

( and its referred...

Just keep in min , SQLServer "uniquifies" every clustered index key !

Clustered Index Uniquifier Existence and Size

oh by the way, if you know [MULE_BATCH_ID] should be unique in that table, create a unique constraint or index.

how about:

Declare @StartYear datetime = '1900-04-01' ;
Declare @StartYearNov datetime = '1900-10-01' ;
SELECT convert(date, dateadd(yy,n,@StartYear)) Dt
     , DATEPART(wk, dateadd(yy,n,@StartYear) ) AS Aprilwk
  ...

For what it's worth: Even last year, I've seen vendors still installing SQL2005 Express with their "state of the art" stuff.

I've always been "the first with who made a fuss...

Indeed.

It is by far THE biggest downside of SQL Paas / Iaas in on Azure!

on top of that, you cannot extend msdb to keep a relevant amount of job history...

Hi Jeff,

That is strange.

I hoped the 'insert/edit code sample' would nutralise all dodgy behaviour of ampersants, etc

-- please see attachment

Keep min mind, with non simple recovery models, transactions are only flagged overwritable during a LOG backup !

To keep your log file size under control, it may require more frequent...

This script gets me all jobs and schedules that have "%backup%" in their steps command.

Just modify to the wanted database name and off you go.

select  ServerName
...

Keep in mind you will need to do some extra validation if to see of jobs address database objects using 4-part naming.

So, the query you'll end up with using the...

check msdb dbo.sysjobs dbo.sysjobsteps dbo.sysjobschedules dbo.sysschedules

1. Why would you put this in a job ?
2. Why don't you just run the Alter in a TSQL jobstep ?

You could try to download the bak file locally ( with e.g. Microsoft Azure Storage Explorer ) and then perform the restore.