uhm, what about "Temporal tables"?

"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.

"SQL Server 2016...

• This reply was modified 1 week ago by  Carlo Romagnano.

UPDATE myTable WITH(NOLOCK) is not permitted by SQL SERVER, so, it's impossible to try.

In any case, I prefer the option "SET TRANSACTION ISOLATION LEVEL SNAPSHOT", so, I can read committed...

The correct answer is "ServerProperty with the EngineEdition". It returns 6 for "Azure Synapse Analytics".

Not Exists vs Not In:

SELECT *

FROM dbo.Candidates AS c

WHERE

NOT exists

( SELECT PersonName FROM dbo.Person WHERE Person.PersonName = c.PersonName);

The correct answer is "Customers_b only", because the definition of primary key is that all column should be "NOT NULLABLE".

In this way you can JOIN tables by the PK without...

From BOL: "If a marked transaction spans multiple databases on the same database server or on different servers, the marks must be recorded in the logs of all the affected...

Instead of views, I use a lot TVF and CTE, the limits are the same as for views.

Here an example:

create table a (i int)
GO
create function myfn_a(@i int)
returns...

From BOL:

REMOTE cannot be used when one of the values being compared in the join predicate is cast to a different collation using the COLLATE clause.

The query fails only if...

The default values for parameters are not stored anywhere in the DMVs.

This statement is incorrect

SELECT ProcName = pr.name
     , ParamName = p.name
...

Typo in answers: sys.modules is wrong, as it stated in the explanation: sys.sql_modules.

I didn't see the dbo schema before OPENJSON.

So the answer is correct, but not the explanation.

The query fails not because of compaibility level, but because of dbo schema before OPENJSON.

SELECT...

To select all rows from CustomerLeft change join precedence by parentheses:

SELECT *
 FROM dbo.CustomerLeft AS cl
 LEFT JOIN (dbo.CustomerContact AS cc 
 INNER JOIN dbo.EmailDomain AS ed...

"All roads lead to Rome!" we say in Italy. It depends on your case.

For Memory optimized premium-series the maximum is 64.

Sorry folks, but the QoD submission some how went wrong.

This was the original explanation

TL;DR; Put a ISNULL around the SUM to ensure a numeric value is always provided, even...