I have not tested this, but any chance you have implicit transactions turned on in your instance?

If not, I'd open up a support case with Microsoft as nobody on this...

My opinion - there is a TON to learn. Heck, I know very little about SQL. Every time I think I know something, someone posts something that contradicts what I...

That is a lot of "insufficient memory" errors... any chance that the box hosting SQL Server is running out of memory?

Failing that, any chance that your service broker has a...

Only 50 MB is being used in the 10 minute timeframe. Looking at the longer time frame we can see more is used, jumping up to nearly 600 MB at...

tempdb is used for all temporary storage required by a query. Temp tables and table variables are the big things that fill it up, but other things can be stored...

To be completely honest with you, I've never tried to open an RDL in SSMS and didn't even know you could... I don't see the point? Is there a reason...

I agree with Ant-Green - test it and see. BUT that being said, the way the bat file is written it would be running command 1 then when that sends...

Also, forgive my ignorance, but what do you mean by the statement

-- In T-SQL, you cannot directly change the owner of a view like in PostgreSQL.

-- You would need to...

So looking at your expected results, your query isn't doing what you want... but I imagine you already knew that, right? You did try running it against your dataset, right?...

Just to confirm, the logs you reviewed are: C:\Program Files\Microsoft SQL Server\MSRS12.SQL2014\Reporting Services\LogFiles (for SQL Server 2014). If memory serves, this can be configured during install time, so that folder...

Since you are not deleting anything out of database2, you could get a performance boost by pulling that table into a table variable/temp table and remove the cross database lookups....

One thing I would point out is adding indexes is something you should do with caution. I know Bedeencion40 said that adding missing indexes was good, but it isn't always...

Even with the sample data, I don't know what your expected output is. Tell me what you expect the output to look like and then I can try to help....

I do agree that this is better posted on an "Oracle" forum, but you are going to hit snags still by asking there. The big question that will come up...

Not red flags, but habits I like to get into. For SQL 2022, you can use the syntax "CREATE OR ALTER" which I find to be much nicer than the...