not enough information to tell you what is the correct way to do for your particular query but the following should point you on the right direction.

select...

sql playing dumb on this case

if your software can be set to do other types of joins/cross applies or even to, as you said, generate the isnull (which works on...

on the server itself (or through xp_cmdshell on that sql instance) execute

tnsping tableau

if the server is names like that you will get an output with the ip/hostname of the server...

very few items from a SQL coding perspective are not available on standard since 2016 SP1 - before yes it was a problem, nowadays not so much unless you are...

and how many cpu/cores/numa nodes does that machine have?

from a functionality point of view they are exactly the same.

its just licensing that is different - install is also same just different license key which determines how cpu/core is...

CAST(SUM(p.QTY * 1.0) / SUM (r.QTY) AS decimal (5,2)) AS 'Forecast Accuracy'

by "forcing" one of the operators to be a decimal the results is now a decimal.

no

what you need to do is not add them to any role that allows data changes (or ddl changes) - e.g. do not add them to db_datawritter or db_ddladmin -...

first step is to change the owner of the database to be either a lowlevel SQL Login created just for that or to SA

ALTER AUTHORIZATION ON database::testdb TO DisabledLogin;

then create...

if the index is partitioned then yes.

alter index indexname on tablename rebuild partition = 3 ...

@homrebrew01

you are right. Even same 2019 versions giving me an error on some servers and some servers it's working fine and sending an alert. something fishy going with the...

Yes and no - majority of cases the merge by the second developer will be without conflicts - only in a few cases will the developer be required to manually...

one way of doing it

Merge manager should decide (within team) which change should go first

developer A
--> Local          ...

regarding SHA1 - it is deprecated for crypt functions - for this type of uses and because it will be on SQL for a very long time I would not...

you need to parse the output - and ensure that you deal with the quirks of different versions of servers/locales as you are now finding out

also fsutil needs administrator privs...