I would suggest looking into Distributed Availability Groups. A Distributed Availability Group is an 'AG of AGs'; it is comprised of two or more AGs. The Primary Replica on the...

Build two lists: the first list is all of the #partattributes code and code types with counts, the second is a list of #test code and code types with counts....

Rebuilding a disabled index does the same work as originally creating it.

The difference between ALTER INDEX ... DISABLE / ALTER INDEX ... REBUILD and DROP INDEX / CREATE INDEX is...

After you disable an index, you will need to rebuild it in order to use it again. Disabling drops all the storage for an index.

If you introduce a decimal type value into the equation, you turn the results from int to decimal. Note the slight difference between the two function calls - one uses...

Change your dynamic SELECT into a dynamic INSERT:

/* instead of: */
set @query = 'SELECT PatientID, LastName, FirstName, .....'

/* use: */
set @query = '
  INSERT temp_table(PatientID, LastName,FirstName,...

You can set up an AG without a cluster in the DR DC. Then you can wire that up to a Distributed AG with the AG in your main DC....

.

Use the ISNULL() function.

ISNULL(<value_to_test>, <result_if_null>)

-- sample data
CREATE TABLE #IsNullTestr(EmpID char(3), TermDate datetime);
INSERT #IsNullTestr(EmpID, TermDate)
  SELECT 'AAA', NULL UNION ALL 
  SELECT 'AAB', '2021-01-01' UNION ALL
...

You'll need to create two AD groups, one for standard users, who should not see the sensitive columns, and one for privileged users, who can.

Drop the 'all logins' group from...

GETDATE(), GETUTCDATE(), etc., are niladic nondeterministic functions.

A niladic function has no parameters. A nondeterministic function returns different values with the same inputs (the exact results of a GETDATE() call cannot be...

If you're running in a Windows domain, and looking for a way to have auto-password management for app service accounts, then look into Managed Service Accounts, such as Group Managed...

...

The Licensing Guide can be downloaded from https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing

You'll quickly note in that doc that there are a variety of ways to buy the licenses with several different enterprise agreement options...

Every value that is being sorted (and there are a LOT of them) are shown as 'Expr1140', 'Expr1141', etc. Those aren't the names of the columns in your tables (I...