I hope this helps.

my control table was in master.  I think i can rustle up my whole old solution if you need it.

CREATE TABLE [dbo].[DBAStatistics_SpecialTreatment] ( 
[DatabaseName]...

I had a somewhat similar issue, in my case, i created a table [dbo].[DBAStatistics_SpecialTreatment]  that had the table, sample rate, and which day of the week it would be executed...

connections that have been established for a long time are not evil.

you mention things are "stuck", but your query is not looking for that. it;s just looking at long connecitosn.

On...

I've got some code for you to help with that.

I inherited some ugly processes that import csv files into tables where every column is an nvarchar(max) , or varchar(max), regardless...

i have done something similar to what pietlinden as posted. mine is a procedure, but same concept, for my results go into a global temp table. it also limits to...

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