wild guess here: AV it was. Proof? Check if the files are in the whitelist for the AV.

Hi,

according to some online documentation all you really need is a jdbc source / sink connector from MSSQL perspective.

Open SQL Server Configuration Manager

I was thinking maybe you are missing a patch for either Windows (more likely) or SQL Server, what comes first to my mind is: Is it a newer AMD Epyc...

I'm not entirely sure if the new CE would do better in such case because as I see it you're in this case with EXISTS expecting 2 different things: a...

• This reply was modified 5 years, 4 months ago by  DinoRS. Reason: typo

well there is a difference if you expect one record since you're forced to believe all you're interested in is one row (IF EXISTS is a boolean condition) or if...

Well I would be happy if we could turn off and on some lights but with our CSP (not a big name) we are at different levels of turning off...

well, direct hardware is always telling the truth, VM's and anything above might lie to you.

have another test and compare the following: Does your TempDB during 215 ms latency show...

Well I'm just starting a project around - let's throw in a buzzy word - "AI Vision". I do this completely in my free time so what might cost me...

• This reply was modified 5 years, 4 months ago by  DinoRS. Reason: spelling

well if you think about what NOLOCK is supposed to do, it does kinda make sense if you have a table with an index on it. Only way for NOLOCK...

I definitely agree with you Jeff that there is something wrong but it's not the data as stands but instead of replacing the logic from the 3rd Party ISV with...

Right Click on the Project -> Properties -> Configuration Properties -> General -> Deployment Target Version.

and before the next question arises (been there myself … this at least holds for...

This behaviour being a bug might aswell just be, unfortunately I have no older versions of SQL Server than 2017 around to test this, I read it might be related...

I tend to believe myself as a "scale-out problem solver", I mean I'm not going for that 10 millisecond query unless the circumstances around it are dumb enough to justify...

• This reply was modified 5 years, 5 months ago by  DinoRS. Reason: typo

I'm hoping for at TCP-E Results at least to be the same with AMD as with Intel, if we're less than 5% off target I'd love to use some AMD...