open a support case in your azure subscription.

You need to grant the sql server...

Can you provide usable DDL of your tables + indexes + views + test data + the failing query?

How to post code problems

Interesting .... you must have pushed to hard to educate.

Such a shame ... especially when someone is willing to fix...

and some times it even throws in a right outer join ( in the mix of LOJ s )

I have noticed some "nested joins" some times can have a positive...

• You need to provide access to the target share or folder

  • to the sql agent service account

OR

<li style="list-style-type: none;">

• to a sqlagent proxy account ( and have...

Every once in...

"...gamedate nvarchar..."  ? Really?

Why aren't you using the correct data type Date / time / Datetime2 ?

Those come with a couple of advantages:

- validation

- calculation/conversion options

- small space consumption

-...

Every once in a while,...

Why are you not just selecting the needed files from msdb and execute the restore statement directly in your sqlagent job using tsql?

did you have a look at "Troubleshooting Service Broker (SSB)"

Extended Events is the way to go.

Have a look at the attached script ( capturing key violations ) to get you started

Why aren't you just using 3 inividual inserts ?

Especially when those perform way better.

it depends:

Have a look at GRANT

and GRANT Server Permissions

GRANT view definition ....

vs


GRANT view ANY definition ...

Last time I checked, you could change master db to full recovery, but it did not actually use full recovery !!

This was a couple of editions ago, so I'll...