i see a couple of things. try my query below.

the first issue, is making sure all your joins switch to left joins, as everyone else pointed out

second, your WHERE statement...

there's an option to call the compose for a specific filename with the -f parameter:  otherwise it assumes the current folder and specific filename

docker compose -f "G:\My Drive\_Data\Docker\DockerCompose\SQL2022.yaml" up -d

without a WHERE statement, I think you are looking at pure disk reads as being the slowdown. reading  110 million records, without doing a group by or anything, is going...

In my environment, we had that port exhaustion/ephemeral port issue with AWS containers, which normally had 5 processes running 10 copies each. We had an isseu where  if the query...

Microsoft Update Catalog has some links, but not that specific one. https://www.catalog.update.microsoft.com/Search.aspx?q=sql%20server%202000

will any of those contain a version you can use?

I use this sql snippet to get servername/ip/port: technically, there could be more than one IP address if you have a multi subnet thing going on:

--desc: gets...

Frederico, that is undoubtedly the answer. all my attempted posts had a couple of links in it. some embedded in test data, and a reference to a previous post on...

ok i found that my code had two urls in it, as i like to document attributes/references to the forum or the source i got the code from.

i pasted just...

attempting to post 4120 chars into a code block

DECLARE @MyExample TABLE (ID int identity(1,1),MyRecipe varchar(max),OtherColumns varchar(30) )
INSERT INTO @MyExample
SELECT '***DUST MASK MUST BE WORN***
ENSURE THE PRODUCT CODE...

attempting to paste 3799 chars into a code block

DECLARE @MyExample TABLE (ID int identity(1,1),MyRecipe varchar(max),OtherColumns varchar(30) )
INSERT INTO @MyExample
SELECT '***DUST MASK MUST BE WORN***
ENSURE THE PRODUCT CODE...

Edit: this posted with a code block, so i think the issue is size related.

yes I've seen the same, effectively, notifications restart again recently, after a long hiatus of just...

• This reply was modified 3 weeks, 2 days ago by Lowell. Reason: confirming this posted

third attempt, without the code: if i paste long replies with lots of code, whether i put it in a code box or not, my reply to the post disappears.

the...

I just had another thought, Also in the SQL Configuration Manager  you'll need to change the IPAll and make sure it is not using a dynamic port, and is listening...

by default, SQL Express has tcp disabled, and you have to explicitly enable that in the SQL Configuration Manager, did you do that yet? that's a difference between what we...

• This reply was modified 1 months ago by Lowell.

also note that if a long statement is in use, like WITH MyCTE..... or a cursor, the error returns the first line of the statement, and not the in between...