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...

From my understanding, that problem comes up when there is an issue in the network stack. It is not usually firewall related. MS support says:

Error 121: "The semaphore timeout period...

Another way to "move" the columns is to change the SELECT order. What I mean is rather than:

SELECT NAME, ID
FROM TABLE

do:

SELECT ID, NAME
FROM TABLE

The...

My opinion - blocking isn't something that needs a DBA to step in. Or at least it SHOULDN'T require a DBA to step in. Blocking should be temporary. If the...

@Drew.Allen - is there a reason you need an artificial column to aggregate on? Couldn't you  use a COUNT on the ID, assuming there are no duplicate rows and if...

Probably a bit messy, but what about using a CASE statement? Something along the lines of:

SELECT ID
    , CASE WHEN EXISTS (SELECT 1
 ...

I could be dumb, but I am pretty sure that "server\database" is not a valid way to connect to a SQL instance. It needs to be server\instance. Otherwise how does...

I just want to add some clarity to Scott's reply - it depends. You CAN have your BAT file run synchronously OR asynchronously. It depends on the BAT file. For...

I generally look for all  logs that I am able to access. In this scenario, the SQL logs (not error logs, but the current SQL Server Logs, or possibly a...