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

Attempting to restart SQL Server instance is a quite common mistake...

depending on what the process is it can either take awhile or require a SQL Instance restart.

Multiple possible reasons depending on what the session was executing.

did you look at the contents of the string as I stated?

did you count the characters and see if your substring matches that output?

are the separaters a "," or a...

that likely has different output on the server with sql 2019 - you should be able to figure out yourself what the issue is as the convert is happening on...

look at

https://sqlquantumleap.com/2018/02/15/safely-and-easily-use-high-level-permissions-without-granting-them-to-anyone-server-level/

and

https://sqlrambling.net/2018/04/24/using-a-certificate-to-sign-a-stored-procedure/

one way of allowing particular functions to work while not granting the permissions directly.