Never used this, but as I understand it, TABLESAMPLE can return any number of rows between zero and all of them depending on how many pages are occupied by the...

Don't know much about this, but it appears to me that the limits apply to Standard-series/Premium-series/Memory optimized premium-series hardware configurations, each of which can be chosen for General Purpose or...

Not sure that answer is correct. From what I've read (e.g. https://cloudblogs.microsoft.com/sqlserver/2022/10/20/intelligent-query-processing-degree-of-parallelism-feedback/), DOP is adjusted down until performance was better at the previous level, at which point it...

"I type to exist" - the modern version of "I think therefore I am".

That's what I...

I guessed wrong based on this sentence in the documentation:

A column master key should be an asymmetric key (a public/private key pair), using the RSA algorithm.

I didn't find...

Correct answer is:
'2018-09-03 11:55:34.0000000 -07:00' is returned

but explanation says:
The conversion takes place correctly and '2018-09-03 04:55:34.0000000 -07:00' is returned.

Explanation is still wrong 🙂

Also, the explanation says:

"The conversion takes place correctly and '2018-09-03 04:55:34.0000000 -07:00' is returned."

Not sure about this one - I thought that UPDATE() returned TRUE if an attempt was made to update the column, regardless of whether the update was successful. Chose the...

But there isn't a data frame called batting...

Being pedantic - question says "What setting should I change?". You shouldn't change RETENTION = ON, you should leave it as it is. But you do have to set it because...