You have no primary keys or indexes. SQL Server has to scan the table for every query/subquery/CTE.

Your datatypes seem questionable.

• Is PortionKey really ever unicode? Your example shows only ASCII...

What queries use those indexes? Do they (always) use the same columns as predicates (where clauses, joins, order bys)?

Any queries that use the index must use the first index key...

Unfortunately, you missed the requirement that the source and target tables must have identical indexes.

A case statement should do it:

    -- Change operators appropriately if not inclusive
    CASE WHEN Amount >= Column1 AND Amount <=...

Assuming you have a CreatedDateTime or equivalent that is always populated (e.g., has a default value & nobody explicitly sets it to null), yes, it seems possible.

You'd probably use a...

Based on To cool datacenter servers, Microsoft turns to boiling liquid => 3M Immersion cooling for data centers, it sounds like it's one of these: Fluorinert™ Electronic Liquids

It's extremely difficult to get even mostly right, and tends to be a trial and error process of discovering and fixing the logic for those that were mishandled... without breaking...

I considered submitting a request asking for a way to suppress the dark mode request.

I actually have to use DATEDIFF_BIG.  The fact they couldn't be bothered to implement the corresponding...

Note that Microsoft is preparing to switch, yet again, to a different feedback system.

Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year....

That link leads you to KB5001090 - Cumulative Update 10 for SQL Server 2019 which has two links:

Microsoft Download Center: Download the latest cumulative update package for SQL Server 2019...

Something like:

CASE WHEN A.currency = B.currency THEN A.value ELSE A.value * C.conversion_rate/100 END

Or, to simplify logic, if you have a self reference in the conversion table for...

What do you mean "I wasn't able to log in"? What error message did you get?

What instance name did you use? For a default instance, you should have been able...

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server?view=sql-server-ver15

tracks all the CUs & GDRs with links.

Correct.

You will need to either delete rows with conflicting data (if you can get away with that... you might want to copy the data to an error table to review...

https://www.sqlservercentral.com/forums/forum/sql-server-2017/sql-server-2017-development is probably more relevant... but close enough.

You can probably use something like

sum(CASE WHEN  rt.ZoneFk = 3 THEN mbs.Count ELSE 0 END)

for the filtered TotalRecordCount.

Beat to...